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.
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.
Microsoft Access
Last Comment
Edualterus
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.
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°)
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
exactly what i needed. thank you very much, Eddie.