MS Access Automating switch from Edit mode to Navigation mode.

40 pts.
Tags:
Access
Access Controls
Access Navigation Pane
Automation
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • orangehat
    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
    1,525 pointsBadges:
    report
  • Pwcky
    [...] MS Access Automating switch from Edit mode to Navigation mode. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following