ACC95: Options Command Differences Between Versions 2.0 and 95
ID: Q136129
|
The information in this article applies to:
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