MS Access Automating switch from Edit mode to Navigation mode.
MS Access, I'm looking for a way through code, property or expression, to emulate F2 key. In other words, as you tab through fields in an Access form to have the cursor enter those fields in edit mode (insertion point at beginning of field) instead of navigation mode where the whole field is highlighted. Even if I have to put something on every field, that's OK, I just don't want the users having to hit F2 or click with the mouse everytime they wanting to update or add to existing field data.
Software/Hardware used:
ms access
Software/Hardware used:
ms access
ASKED:
April 7, 2011 4:16 PM
UPDATED:
April 8, 2011 4:01 PM
Answer Wiki:
Change 'Behavior entering field' from 'select entire field' to 'go to start of field'
to change in 2007:
click on 'Office Button',
select 'Access Options' on lower right corner of screen
select 'Advanced' << 2nd option down on this screen.
To see all answers submitted to the Answer Wiki: View Answer History.
If by change you want to do via vba add some vba code to the ‘on open’ function for that form. This way you can change what each form does as it’s opened.
i.e.
Private Sub Form_Open(Cancel As Integer)
Application.SetOption “Behavior entering field”, 0 ‘ Select entire field
Application.SetOption “Behavior entering field”, 1 ‘ Go to start of field
Application.SetOption “Behavior entering field”, 2 ‘ Go to end of field
End Sub