Show All
Set Options from Visual Basic
You can use the SetOption
and GetOption
methods to set and return option values in the Options dialog box from code. To view the Options dialog box, click Options on the Tools menu.
The following tables list the names of all options that can be set or returned from code and the tabs on which they can be found in the Options dialog box, followed by the corresponding string argument that you must pass to the SetOption or GetOption method.
Notes
If your database may run on a version of Microsoft Access for a language other than the one in which you created it, then you must supply the arguments for the GetOption and SetOption methods in English.
Some options are available only within a Microsoft Access database (.mdb) or Access project (.adp).
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 |
General Tab
| Option text |
String argument |
| Print margins, Left margin |
Left Margin |
| Print margins, Right margin |
Right Margin |
| Print margins, Top margin |
Top Margin |
| Print margins, Bottom margin |
Bottom Margin |
| Use four-year digit year formatting, This database |
Four-Digit Year Formatting |
| Use four-year digit year formatting, All databases |
Four-Digit Year Formatting All Databases |
| Name AutoCorrect, Track name AutoCorrect info |
Track Name AutoCorrect Info |
| Name AutoCorrect, Perform name AutoCorrect |
Perform Name AutoCorrect |
| Name AutoCorrect, Log name AutoCorrect changes |
Log Name AutoCorrect Changes |
| Recently used file list |
Enable MRU File List |
| Recently used file list, (number of files) |
Size of MRU File List |
| Provide feedback with sound |
Provide Feedback with Sound |
| Compact on Close |
Auto Compact |
| New database sort order |
New Database Sort Order |
| Remove personal information from file properties on save |
Remove Personal Information |
| Default database folder |
Default Database Directory |
Edit/Find Tab
| Option text |
String argument |
| Default find/replace behavior |
Default Find/Replace Behavior |
| Confirm, Record changes |
Confirm Record Changes |
| Confirm, Document deletions |
Confirm Document Deletions |
| Confirm, Action queries |
Confirm Action Queries |
| Show list of values in, Local indexed fields |
Show Values in Indexed |
| Show list of values in, Local nonindexed fields |
Show Values in Non-Indexed |
| Show list of values in, ODBC fields |
Show Values in Remote |
| Show list of values in, Records in local snapshot |
Show Values in Snapshot |
| Show list of values in, Records at server |
Show Values in Server |
| Don't display lists where more than this number of records read |
Show Values Limit |
Datasheet Tab
| Option text |
String argument |
| Default colors, Font |
Default Font Color |
| Default colors, Background |
Default Background Color |
| Default colors, Gridlines |
Default Gridlines Color |
| Default gridlines showing, Horizontal |
Default Gridlines Horizontal |
| Default gridlines showing, Vertical |
Default Gridlines Vertical |
| Default column width |
Default Column Width |
| Default font, Font |
Default Font Name |
| Default font, Weight |
Default Font Weight |
| Default font, Size |
Default Font Size |
| Default font, Underline |
Default Font Underline |
| Default font, Italic |
Default Font Italic |
| Default cell effect |
Default Cell Effect |
| Show animations |
Show Animations |
| Show Smart Tags on Datasheets | Show Smart Tags on Datasheets |
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 |
| Auto commit |
Ime Autocommit |
| Datasheet IME control |
Datasheet Ime Control |
Tables/Queries Tab
| Option text |
String argument |
| Table design, Default field sizes - Text |
Default Text Field Size |
| Table design, Default field sizes - Number |
Default Number Field Size |
| Table design, Default field type |
Default Field Type |
| Table design, AutoIndex on Import/Create |
AutoIndex on Import/Create |
| Query design, Show table names |
Show Table Names |
| Query design, Output all fields |
Output All Fields |
| Query design, Enable AutoJoin |
Enable AutoJoin |
| Query design, Run permissions |
Run Permissions |
| Query design, SQL Server Compatible Syntax (ANSI 92) - This database |
ANSI Query Mode |
| Query design, SQL Server Compatible Syntax (ANSI 92) - Default for new databases |
ANSI Query Mode Default |
| Query design, Query design font, Font | Query Design Font Name |
| Query design, Query design font, Size | Query Design Font Size |
| Show Property Update Options buttons | Show Property Update Options buttons |
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 |
| Show Smart Tags on Forms | Show Smart Tags on Forms |
| Show Windows Themed Controls on Forms | Themed Form Controls |
Advanced Tab
| Option text |
String argument |
| DDE operations, Ignore DDE requests |
Ignore DDE Requests |
| DDE operations, Enable DDE refresh |
Enable DDE Refresh |
| Default File Format |
Default File Format |
| Default open mode |
Default Open Mode for Databases |
| Command-line arguments |
Command-Line Arguments |
| OLE/DDE timeout (sec) |
OLE/DDE Timeout (sec) |
| Default record locking |
Default Record Locking |
| 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) |
| Open databases using record-level locking |
Use Row Level Locking |
Pages Tab
| Option text |
String argument |
| Default Designer Properties, Section Indent |
Section Indent |
| Default Designer Properties, Alternate Row Color |
Alternate Row Color |
| Default Designer Properties, Caption Section Style |
Caption Section Style |
| Default Designer Properties, Footer Section Style |
Footer Section Style |
| Default Database/Project Properties, Use Default Page Folder |
Use Default Page Folder |
| Default Database/Project Properties, Default Page Folder |
Default Page Folder |
| Default Database/Project Properties, Use Default Connection File |
Use Default Connection File |
| Default Database/Project Properties, Default Connection File |
Default Connection File |
Spelling Tab
| Option text |
String argument |
| Dictionary Language |
Spelling dictionary language |
| Add words to |
Spelling add words to |
| Suggest from main dictionary only |
Spelling suggest from main dictionary only |
| Ignore words in UPPERCASE |
Spelling ignore words in UPPERCASE |
| Ignore words with numbers |
Spelling ignore words with number |
| Ignore Internet and file addresses |
Spelling ignore Internet and file addresses |
| Language-specific, German: Use post-reform rules |
Spelling use German post-reform rules |
| Language-specific, Korean: Combine aux verb/adj. |
Spelling combine aux verb/adj |
| Language-specific, Korean: Search misused word list |
Spelling use auto-change list |
| Language-specific, Korean: Process compound nouns |
Spelling process compound nouns |
| Language-specific, Hebrew modes |
Spelling Hebrew modes |
| Language-specific, Arabic modes |
Spelling Arabic modes |
International Tab
| Option text |
String argument |
| Right-to-Left, Default direction |
Default direction |
| Right-to-Left, General alignment |
General alignment |
| Right-to-Left, Cursor movement |
Cursor movement |
| Use Hijri Calendar |
Use Hijri Calendar |
Error Checking Tab
| Option text |
String argument |
| Settings, Enable error checking |
Enable Error Checking |
| Settings, Error indicator color |
Error Checking Indicator Color |
| Form/Report Design Rules, Unassociated label and control |
Unassociated Label and Control Error Checking |
| Form/Report Design Rules, New unassociated labels |
New Unassociated Label Error Checking
|
| Form/Report Design Rules, Keyboard shortcut errors |
Keyboard Shortcut Errors Error Checking |
| Form/Report Design Rules, Invalid control properties |
Invalid Control Properties Error Checking
|
| Form/Report Design Rules, Common report errors |
Common Report Errors Error Checking |
Note If you are developing a database application, add-in, library database, or referenced database, make sure that the Error Trapping option is set to 2 (Break On Unhandled Errors) when you have finished debugging your code.
The value that you pass to the SetOption method as the setting argument depends on which type of option you are setting. The following table establishes some guidelines for setting options.
| If the option is |
Then the setting argument is |
| A text box |
A string |
| A check box |
A Boolean value— True (–1) or False (0) |
| An option button in an option group, or an option in a combo box or a list box |
An integer corresponding to the option's position in the option group or list (starting with zero [0]) |
