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

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

Option text	String argument
Show
Status bar	Show Status Bar
Startup dialog box	Show Startup Dialog Box
New object shortcuts	Show New Object Shortcuts
Hidden objects	Show Hidden Objects
System objects	Show System Objects
Windows in Taskbar	ShowWindowsInTaskbar
Show in macro design
Names column	Show Macro Names Column
Conditions column	Show Conditions Column
Click options in database window	Database Explorer Click Behavior
Dual font support
Use substitute font	Enable Font Switching
Substitute font name	Substitute Font Name

General Tab

Option text	String argument
Print margins
Left Margin	Left Margin
Right Margin	Right Margin
Top Margin	Top Margin
Bottom Margin	Bottom Margin
Default database folder	Default Database Directory
Recently used file list	Enable MRU File List
# of recently used file list	Size of MRU File List
Provide feedback with sound	Provide Feedback With Sound
Compact current database	Auto Compact
Compact when database will shrink by this percentage or more	Auto Compact Percentage
Name AutoCorrect (MDB only)
Track name AutoCorrect info	Track Name AutoCorrect Info
Perform name AutoCorrect	Perform Name AutoCorrect
Log name AutoCorrect changes	Log Name AutoCorrect Changes
New database sort order (MDB only)	New Database Sort Order
Use four-digit year formatting	Four-Digit Year Formatting

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.

Option text	String argument
Hyperlink color	Hyperlink Color
Followed Hyperlink color	Followed Hyperlink color
Underline hyperlinks	Underline Hyperlinks
* Show Hyperlink Addresses In Status Bar	Note: Not valid for Microsoft Access 2000. Address shown in tooltips.
* HTML Template	HTML Template
* Data Source Name	Data Source Name
* User Name	User Name
* Password	Password
* Server URL	Active Server Pages URL
* Session Timeout	Active Server Pages Session Timeout

Edit/Find Tab

Option text	String argument
Default find/replace behavior	Default Find/Replace Behavior
Confirm
Record changes	Confirm Record Changes
Document deletions	Confirm Document Deletions
Action queries (MDB only)	Confirm Action Queries
Show list of values in (MDB only)
Local indexed fields	Show Values In Indexed
Local nonindexed fields	Show Values In Non-Indexed
ODBC fields	Show Values In Remote
Don't display lists where more than this number of records read	Show Values Limit
Show list of values in (ADP only)
Records in local snapshot	Show Values In Snapshot
Records at server	Show Values In Server
Don't display lists where more than this number of records read	Show Values Limit

Keyboard Tab

Option text	String argument
Move after enter	Move After Enter
Behavior entering field	Behavior Entering Field
Arrow Key Behavior	Arrow Key Behavior
Cursor Stops At First/Last Field	Cursor Stops at First/Last Field

Datasheet Tab

Option text	String argument
Default Colors
Font	Default Font Color
Background	Default Background Color
Gridlines	Default Gridlines Color
Default gridlines showing
Horizontal	Default Gridlines Horizontal
Vertical	Default Gridlines Vertical
Default column width	Default Column Width
Default Font
Font	Default Font Name
Weight	Default Font Weight
Size	Default Font Size
Underline	Default Font Underline
Italic	Default Font Italic
Default cell effect	Default Cell Effect
Show animations	Show Animations

Forms/Reports Tab

Option text	String argument
Selection Behavior	Selection Behavior
Form template	Form Template
Report template	Report Template
Always use event procedures	Always Use Event Procedures

Advanced Tab (MDB Only)

Option text	String argument
Ignore DDE Requests	Ignore DDE Requests
Enable DDE Refresh	Enable DDE Refresh
Default Open Mode	Default Open Mode for Databases
Command-Line Arguments	Command-Line Arguments
OLE/DDE Timeout (Sec)	OLE/DDE Timeout (Sec)
Refresh Interval (Sec)	Refresh Interval (Sec)
Number Of Update Retries	Number of Update Retries
ODBC Refresh Interval (Sec)	ODBC Refresh Interval (Sec)
Update Retry Interval (Msec)	Update Retry Interval (Msec)
Default Record Locking	Default Record Locking
Use Record Level Locking	Use Row Level Locking

Advanced Tab (ADP Only)

Option text	String argument
DDE operations
Ignore DDE Requests	Ignore DDE Requests
Enable DDE Refresh	Enable DDE Refresh
Default Max Records	Row Limit
Save login and password	Save Login And Password
Command-Line Arguments	Command-Line Arguments
OLE/DDE Timeout (Sec)	OLE/DDE Timeout (Sec)

Tables/Queries Tab (MDB Only)

Option text	String argument
Default field sizes
Text	Default Text Field Size
Number	Default Number Field Size
Default Field Type	Default Field Type
AutoIndex On Import/Create	AutoIndex On Import/Create
Show table names	Show Table Names
Output all fields	Output All Fields
Enable AutoJoin	Enable AutoJoin
Run Permissions	Run Permissions

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