O'Reilly logo

Access 2003 VBA Programmer's Reference by Armen Stein, Graham Seach, Teresa Hennig, Patricia Cardoza

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 textString argument
Show, Status barShow Status Bar
Show, Startup Task PaneShow Startup Dialog Box
Show, New object shortcutsShow New Object Shortcuts
Show, Hidden objectsShow Hidden Objects
Show, System objectsShow System Objects
Show, Windows in TaskbarShowWindowsInTaskbar
Show in Macro Design, Names columnShow Macro Names Column
Show in Macro Design, Conditions columnShow Conditions Column
Click options in database windowDatabase Explorer Click Behavior
E.25.1.2. General Tab
Option textString argument
Print margins, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required