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 TabCollapse this tableExpand this table
| 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 |
Collapse this tableExpand this table
| 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 |
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.
Collapse this tableExpand this table
| 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 |
Collapse this tableExpand this table
| 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 |
Collapse this tableExpand this table
| 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 |
Collapse this tableExpand this table
| 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 |
Collapse this tableExpand this table
| Option text | String argument |
|---|
| Selection Behavior | Selection Behavior |
| Form template | Form Template |
| Report template | Report Template |
| Always use event procedures | Always Use Event Procedures |
Collapse this tableExpand this table
| 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 |
Collapse this tableExpand this table
| 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) |
Collapse this tableExpand this table
| 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