using VBA to set a keyboard option setting

[Paul]

Is there a way I can get VBA (Access 2003) to set a keyboard option setting
on the desktops of all users of an application?

I would like to set the "Behavior entering field" setting in the
Tools-Options-Keyboard (tab) dialog set to "Go to end of field", and I would
like to do it using VBA. Is there a way to accomplish this?

Thanks in advance,

Paul

 

[Paul]

Thanks for suggesting the Application.SetOption approach, Pieter.

After some experimentation, I found that

Application.SetOption "Behavior entering field", 2

would do the trick.

Paul

Is there a way I can get VBA (Access 2003) to set a keyboard option
setting
on the desktops of all users of an application?

[quoted text clipped - 6 lines]

Paul

something like...
Application.SetOption "Behavior entering field", "Go to end of field"

 

[Paul]

You have to understand that changing options individual users have set is
never a good idea.

Never? How can you be sure if you don't know anything about the workgroup
for which I'm doing this, or my role in that workgroup?