ACC95: Options Command Differences Between Versions 2.0 and 95

Last reviewed: May 21, 1997
Article ID: Q136129

The information in this article applies to:

Microsoft Access version 7.0

SUMMARY

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

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                   <Not available>
First Week                      <Not available>
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            <Not available>

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          <Not available>
Show Grid                     <Not available>
Selection Behavior            Tools menu; Options command; Form/Report Tab
Show Ruler                    <Not available>
Move Enclosed Controls        <Not available>
Control Wizards               <Not available>

Datasheet Category

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

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

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

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

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

REFERENCES

For more information about the Options command, search on the word "Options," and then view "Customize the Microsoft Access environment by setting defaults" using the Answer Wizard from the Microsoft Access 7.0 Help menu.

Keywords : kbui UifMenub
Version : 7.0
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.