How do youget access to suggest an entry from previously entered field data likeExcel

[TechNomad]

How do you get Access to suggest an entry (value) from previously entered field data as you type like MS Excel?



I have Windows XP sp3 with Excel 2007.

[ajetrumpet]

you can do that by typing values into combo boxes. It will, however, NOT give you the values of that field but rather the values that are IN the combo list, which are gotten by the sql statement or query.

i don't think you can do this, easily anyhow, with actual textboxes.

also, you can hide the fact that a combo box is actually a combo box by placing other controls over it, etc... to make it seem as though it's working just like excel.

[khalid]

As Adam described combo box is also good for previously entered data:
but you can use the flowing hotkeys to Edit your data

Entering data in Datasheet or Form view

To do this Press
To insert the current date

CTRL+SEMICOLON (

To insert the current time

CTRL+SHIFT+COLON (

To insert the default value for a field

CTRL+ALT+SPACEBAR

To insert the value from the same field in the previous record

CTRL+APOSTROPHE (')

To add a new record

CTRL+PLUS SIGN (+)

To delete the current record

CTRL+MINUS SIGN (-)

To save changes to the current record

SHIFT+ENTER

To switch between the values in a check box or option button

SPACEBAR

To insert a new line

CTRL+ENTER

[TechNomad]

Thank you both! Both of those suggestions are really good. I think I will be using those tips a lot.

[khalid]

Thank you both! Both of those suggestions are really good. I think I will be using those tips a lot.

Glad that it help!