Link to home
Start Free TrialLog in
Avatar of Edualterus
Edualterus

asked on

MS Access 2010 keyboard arrows up and down

hi,

i have an Access 2010 form with many fields but i use only 1 field for data entry purposes. i managed to figured out how to make the cursor go down when clicking enter, but when i use the up or down arrow keys the cursor will go left or right. is there a way to make the arrows go up and down a field like in excel sheet? thank you, Eddie.
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

If your form is a datasheet it would behave much like an excel spreadsheet when it comes to navigation.  Since you are using a continuous form, you could set the AutoTab property of the other fields to No.
You can trap the keys to do whatever you want.

http://support.microsoft.com/kb/113547
If you only need one field to be editable, set the others “Tab Stop” property to “No” (IrogSinta's idea) or even “Enabled: No” and “Locked: Yes”, making them much like labels (change their appearance as well in that case).

Trapping the keyboard events (jpaulino's idea) makes sense in more complex cases, but be prepared for a significant development time. The number of special cases and exceptions to consider is quite surprising...

(°v°)
The number of special cases and exceptions to consider is quite surprising...
Oh so true...
:-)
ASKER CERTIFIED SOLUTION
Avatar of clarkscott
clarkscott
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Edualterus
Edualterus

ASKER

exactly what i needed. thank you very much, Eddie.