ACC95: Options Command Differences Between Versions 2.0 and 95

ID: Q136129


The information in this article applies to:
  • Microsoft Access 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
Issue type : kbinfo


Last Reviewed: April 23, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.