How set options in Tools--Options--View

F

Fred Boer

Hello:

You can set these options in code using Application.SetOption. For example,
in OnOpen event of the first form of your application, you could have the
following, which sets an option for keyboard behaviour:

Application.SetOption "Behavior Entering Field", 1


You can set all kinds of options this way; there is a table in VBA help.
(Index: SetOptions; Topic "Set options from Visual Basic") However, one
caution: the setting change will affect all your Access files, since it sets
the option for the Access application, not the specific mdb/mde..


Hope this helps!


Fred Boer
 
G

George Nicholson

Application.SetOption "Show Status Bar", True

See the "SetOption" Help entry for more details. That entry also provides a
link to a list of the *exact* spelling for valid arguments so you don't have
to guess. (i.e., "Show Status Bar")

HTH,
 
Top