Access 2003 VBA Programmer's Reference

E.25. Other Helpful Information

We've provided you with a lot of information about the Access object model in this appendix. In addition to the basic objects you'll manipulate on a daily basis, you'll need to know some of the myriad of arguments you can use with some of these objects. The following tables detail some of the arguments for a few selected objects and methods.

E.25.1. Application.SetOption Method

The SetOption method of the Application object allows you to control all of the options you can see by selecting Tools | Options from the main Access window. The following tables detail the string arguments for the options available on each tab. For example, to control the visibility of the Status Bar within your Access application, you'd use the following code.

Application.SetOption "Show Status Bar", True

The arguments you'll need to manipulate the SetOption method are broken down by the tab of the Options dialog box on which they appear.

E.25.1.1. View Tab

Option text	String argument
Show, Status bar	Show Status Bar
Show, Startup Task Pane	Show Startup Dialog Box
Show, New object shortcuts	Show New Object Shortcuts
Show, Hidden objects	Show Hidden Objects
Show, System objects	Show System Objects
Show, Windows in Taskbar	ShowWindowsInTaskbar
Show in Macro Design, Names column	Show Macro Names Column
Show in Macro Design, Conditions column	Show Conditions Column
Click options in database window	Database Explorer Click Behavior

E.25.1.2. General Tab

Option text	String argument
Print margins, ...