Microsoft KB Archive/216888

= ACC2000: Complete List of Arguments That You Can Use with the GetOption and SetOption Methods =

Article ID: 216888

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q216888



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
This article lists all of the arguments that you can use with the GetOption and SetOption methods.



MORE INFORMATION
The Microsoft Access 2000 Help file that lists string arguments of the GetOption and SetOption methods is not complete. The following table lists all of the possible arguments.

View Tab

General Tab

WebOptions Button (General tab)

Options with an asterisk (*) are listed for backward compatibility. With the exception of the Show Hyperlink Addresses In Status Bar option, all other options are hidden but can be set with the SetOption method.

For more information about Web options, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type DefaultWebOptions property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Edit/Find Tab

Keyboard Tab

Datasheet Tab

Forms/Reports Tab

Advanced Tab (MDB Only)

Advanced Tab (ADP Only)

Tables/Queries Tab (MDB Only)

To illustrate how you would programmatically apply one of these options, click Options on the Tools menu in Access 2000, and then click the View tab. Note the Click options in database window in the lower-left corner of the Options dialog. Each time that you open the database, you may want to ensure that all database objects are opened with a single-click instead of a double-click. To do so, you could call the following function from an Autoexec macro each time that the database is opened: Function fncSetOption 'Use 0 (i.e. zero) for Single-click option. 'Use 1 for Double-click option. Application.SetOption "Database Explorer Click Behavior", 0 End Function

