Change Keyboard Behavior for a Form (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Topic

New Reply

Currently my Options.., Keyboard, Behavior entering field, is set to Select entire field.

Is there a way in code when a particular form is opened to change this behavior to Go to end of field for all fields on the form without having to handle each field individually like I am now with something like On_Enter set to Screen.ActiveControl.SelStart = Screen.ActiveControl.SelLength?

Thanks, John

Reply | Quote

Replies

You could use the following code in the form module:

Above all Subs and Functions:

Private intOpt As Integer

Anywhere below that:

Private Sub Form_Activate()
intOpt = GetOption("Behavior Entering Field")
SetOption "Behavior Entering Field", 2
End Sub

Private Sub Form_Deactivate()
SetOption "Behavior Entering Field", intOpt
End Sub

This code sets Behavior entering field to End of field when the form is activated, and resets the default setting when the form is deactivated.

Reply | Quote

I like that, opens up a lot of possibilities!

Thanks, John

Reply | Quote

This procedure is something I would like to use. Is there a reason why this technique will not work with Access97?

Thank you,
Ron

Reply | Quote

If I remember correctly, this code would also work in Access 97.

Reply | Quote

For some reason the code does not change the keyboard options as desired. I even made a copy and converted the database to A2K and it will not make the changes there either. Any other ideas?

Thank you.
Ron

Reply | Quote

Sorry, no. It works for me in Access 2002 and 2003, and I can’t easily test in Access 97 any more.

Reply | Quote

The code that you have works just fine in 97 and 02 – – – when the form is not popup or modal.

Thanks again
Ron

Reply | Quote

The On Activate and On Deactivate events do not occur for a popup form, so the code will not work for a popup form.

The events do occur for a modal form though, so the code should work for a form that is modal but not popup…

Reply | Quote

The popup form was the culprit. Thanks again!

Ron

Reply | Quote

You could use the On Load and On Close events of a popup form. The disadvantage is that the option won’t be reset when the user clicks away from the popup form. But if the form is popup AND modal, the user can’t do that, so using the On Load and On Close events is sufficient.

Reply | Quote

Thank you for the additional information.

Ron

Reply | Quote