Microsoft KB Archive/136129

= ACC95: Options Command Differences Between Versions 2.0 and 95 =

Article ID: 136129

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q136129



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
When you upgrade to Microsoft Access for Windows 95 version 7.0, you may notice that the Options command has moved to the Tools menu and many of its settings have been renamed or reorganized. This article lists the differences in the Option command settings between Microsoft Access version 2.0 and Microsoft Access 7.0.



MORE INFORMATION
The following tables list the option settings from the Options command in Microsoft Access 2.0 with their new locations in Microsoft Access 7.0.

General Category
Microsoft Access 2.0 Option    Microsoft Access 7.0 Location -

Show Status Bar                Tools menu; Options command; View Tab Show System Objects            Tools menu; Options command; View Tab OLE/DDE Timeout (sec) 30       Tools menu; Options command; Advanced Tab Built-In Toolbars Available    Tools menu; Startup command Confirm Document Deletions     Tools menu; Options command; Edit/Find Tab Confirm Action Queries         Tools menu; Options command; Edit/Find Tab New Database Sort Order        Tools menu; Options command; General Tab Ignore DDE Requests            Tools menu; Options command; Advanced Tab Default Find/Replace Behavior  Tools menu; Options command; Edit/Find Tab Default Database Directory     Tools menu; Options command; General Tab Confirm Record Changes         Tools menu; Options command; Edit/Find Tab Can Customize Toolbars         Tools menu; Startup command Enable DDE Refresh             Tools menu; Options command; Advanced Tab First Weekday                   First Week                      Show ToolTips                  Tools menu; Options command; View Tab Color Buttons on Toolbars      Tools menu; Options command; View Tab Large Toolbar Buttons          Tools menu; Options command; View Tab

Keyboard Category
Microsoft Access 2.0 Option    Microsoft Access 7.0 Location -

Arrow Key Behavior             Tools menu; Options command; Keyboard Tab Move After Enter               Tools menu; Options command; Keyboard Tab Cursor Stops at  First/Last Field             Tools menu; Options command; Keyboard Tab Key Assignment Macro           

Printing Category
Microsoft Access 2.0 Option    Microsoft Access 7.0 Location -

Left Margin                    Tools menu; Options command; General Tab Right Margin                   Tools menu; Options command; General Tab Top Margin                     Tools menu; Options command; General Tab Bottom Margin                  Tools menu; Options command; General Tab

Form and Report Design Category
Microsoft Access 2.0 Option  Microsoft Access 7.0 Location ---

Form Template                Tools menu; Options command; Form/Report Tab Report Template              Tools menu; Options command; Form/Report Tab Objects Snap to Grid          Show Grid                     Selection Behavior           Tools menu; Options command; Form/Report Tab Show Ruler                    Move Enclosed Controls        Control Wizards              

Datasheet Category
<pre class="fixed_text">Microsoft Access 2.0 Option  Microsoft Access 7.0 Location ---

Default Gridlines Behavior   Tools menu; Options command; Datasheet Tab Default ColumnWidth          Tools menu; Options command; Datasheet Tab Default FontName             Tools menu; Options command; Datasheet Tab Default FontSize             Tools menu; Options command; Datasheet Tab Default FontWeight           Tools menu; Options command; Datasheet Tab Default Font Italic          Tools menu; Options command; Datasheet Tab Default Font Underline       Tools menu; Options command; Datasheet Tab

Query Design Category
<pre class="fixed_text">Microsoft Access 2.0 Option  Microsoft Access 7.0 Location ---

Output All Fields            Tools menu; Options command; Tables/Queries Tab Run Permissions              Tools menu; Options command; Tables/Queries Tab Show Table Names             Tools menu; Options command; Tables/Queries Tab

Macro Design Category
<pre class="fixed_text">Microsoft Access 2.0 Option  Microsoft Access 7.0 Location ---

Show Macro Names Column      Tools menu; Options command; View Tab Show Conditions Column       Tools menu; Options command; View Tab

Module Design Category
<pre class="fixed_text">Microsoft Access 2.0 Option  Microsoft Access 7.0 Location ---

Syntax Checking              Tools menu; Options command; Module Tab Tab Stop Width               Tools menu; Options command; Module Tab

Multiuser/ODBC Category
<pre class="fixed_text">Microsoft Access 2.0 Option      Microsoft Access 7.0 Location ---

Default Record Locking           Tools menu; Options command; Advanced Tab Default Open Mode for Databases  Tools menu; Options command; Advanced Tab Refresh Interval (sec)           Tools menu; Options command; Advanced Tab Update Retry Interval (msec)     Tools menu; Options command; Advanced Tab Number of Update Retries         Tools menu; Options command; Advanced Tab ODBC Refresh Interval (sec)      Tools menu; Options command; Advanced Tab

Removed Options in Microsoft Access 7.0 ---

The following table lists options that are no longer available from the Options command in Microsoft Access 7.0.

Tab               Option -

General           First Weekday First Week

Keyboard          Key Assignment Macro

Form & Report     Objects Snap to Grid Show Object Show Ruler Move Enclosed Controls Control Wizard

Datasheet         Default ColumnWidth

New Options in Microsoft Access 7.0 ---

The following table lists the new options that are available from the Options command on the Tools menu in Microsoft Access 7.0.

Tab         Group/Option               Option --

View        Show                       Startup Dialog Box Hidden Objects

Edit/Find   Filter by Form Defaults (database specific)     Show list of values in                                        Don't display lists where more than this number of records read

Datasheet   Default Colors             Font Background Gridlines Default Gridlines Showing Horizontal Vertical Default Cell Effect       Flat Raised Sunken Show Animations

Tables/ Queries  Table Design               Default Field Sizes Text Number Default Field Type AutoIndex on Import/Create Query Design              Enable AutoJoin

Keyboard    Behavior Entering Field    Select Entire Field Go to Start of Field Go to End of Field

Module      Code Colors                Text Area Foreground Background Coding Options            Auto Indent Auto Syntax Check Break on all Errors Require Variable Declaration Compile On Demand Font Size Code View                 Full Module View Procedure Separator Current Database Only Command Line Arguments Conditional Compilation Arguments

<div class="references_section">