Current Database category (Access Options)

Note: The options on this tab apply to the current (open) database only.

Application Options

  • Application Title    Type a name for your database. The name appears in the Windows title bar.

  • Application Icon    Type the name of a bitmap (.bmp) or icon (.ico) file. The image will appear in the Windows title bar. Click Browse to display the Icon Browser dialog box and locate an image file.

  • Use as Form and Report Icon    When you select an application icon, this option places the icon in the tabs atop the forms and reports in the currently open database. If you turn off document tabs, the icon does not appear elsewhere.

  • Display Form    Sets, changes, or removes the form that opens automatically when you start a database. If you don't want a form to open, select (none). You must close and reopen the current database for the specified option to take effect.

  • Display Status Bar    Shows or hides the status bar at the bottom of the Access workspace. You must close and reopen the current database for the specified option to take effect.

  • Document Window Options    

    • Overlapping Windows    Allows you to open and view multiple screens in Microsoft Office Access 2007. Hiding the Navigation Pane and selecting this option is as close as you can get to a "classic" view. You must close and reopen the current database for the specified option to take effect.

    • Tabbed Documents    Allows you to use the single-document interface and display a single object at a time. This is the default option. You must close and reopen the current database for the specified option to take effect.

  • Display Document Tabs    Turns on or off the tabs that appear at the top of any open database objects. This setting turns off only the tabs, and does not close tabbed objects themselves or enable "classic" view. You must close and reopen the current database for the specified option to take effect.

  • Use Access Special Keys    Enables or disables the following accelerator keys:

Keys

Result

F11

Shows and hides Navigation Pane.

CTRL+G

Shows the Immediate window in the Visual Basic Editor.

ALT+F11

Starts the Visual Basic Editor.

CTRL+BREAK

When working with an Office Access 2007 project, pressing this key combination stops Access from retrieving records from the server.

  • You must close and reopen the current database for the specified option to take effect.

  • Compact on Close    Automatically compacts and repairs your databases when you close them. You must close and reopen the current database for the specified option to take effect.

  • Remove personal information from file properties on save    Automatically removes personal information from the file properties when you save the file. You must close and reopen the current database for the specified option to take effect.

  • Use Windows-themed Controls on Forms    Uses your Windows theme on the controls on your forms and reports. This setting applies only when you use a Windows theme other than the standard theme.

  • Enable Layout View for this database    Shows or hides the Layout View button on the Access status bar and in the shortcut menus that appear when you right-click an object tab. Remember that Layout view can be disabled for individual database objects, so even when you enable this option, it might not always be available.

  • Enable design changes for tables in Datasheet view    Allows you to change the design of tables while you work in Datasheet view.

  • Check for truncated number fields    When this option is enabled, numbers appear as "#####" when the column is too narrow to display the entire value. When this option is not enabled, you see only part of the values in a column.

  • Picture Property Storage Format    

    • Preserve source image format (smaller file size)    When this option is selected, Access stores images in their original format. Select this option to reduce database size.

    • Convert all picture data to bitmaps (compatible with Access 2003 and earlier)    When this option is selected, Access creates a copy of the original image file in either the Windows Bitmap or Device Independent Bitmap formats. Select this option to view images in databases created in Office Access 2003 and earlier.

Navigation

  • Display Navigation Pane    Shows or hides the Navigation Pane. If you hide the pane accidentally, press F11 to show it. By default, Access no longer provides the Database window. You must close and reopen the current database for the specified option to take effect.

  • Navigation Options    Displays the Navigation Options dialog box. Use the dialog box to change the categories and groups that appear in the Navigation Pane.

    For more information about using the Navigation Options dialog box, see the article Guide to the Navigation Pane.

Ribbon and Toolbar Options

  • Ribbon Name    Select the name of a custom Ribbon group from the list. You must close and reopen the current database for the specified option to take effect.

    Note: The Ribbon is part of the Microsoft Office Fluent user interface.

  • Shortcut Menu Bar    Set or change the default menu bar for shortcut menus. You must close and reopen the current database for the specified option to take effect.

  • Allow Full Menus    When this check box is cleared, all tabs on the default Ribbon are hidden with the exception of the Home tab. In addition, only the Close Database and Exit Access commands are available when you click the Microsoft Office Button Office button image .

    Note: 

    • You must close and reopen the current database for the specified setting to take effect.

    • To temporarily restore the default Ribbon and Microsoft Office Button Office button image commands, close the database, and then reopen the database while holding down the SHIFT key. After using this method to open the database, you can permanently restore the default Ribbon and Microsoft Office Button Office button image commands by returning to the Access Options dialog box, and then under Current Database, under Ribbon and Toolbar Options, selecting the Allow Full Menus check box.

      Note: 

  • Allow Default Shortcut Menus    Turns on or off the shortcut (pop-up) menus that appear when you right-click a database object in the Navigation Pane or a control on a form or report. You must close and reopen the current database for the specified option to take effect.

Name AutoCorrect Options

  • Track name AutoCorrect info    Access stores the information needed to correct naming errors. However, Access does not repair errors until you select the Perform name AutoCorrect option. You must close and reopen the current database for the specified option to take effect.

  • Perform name AutoCorrect    Access repairs naming errors as they occur. If you select the Track name AutoCorrect info option and leave this option blank, Access stores any error data until you select this option. You must close and reopen the current database for the specified option to take effect.

  • Log name AutoCorrect changes    Access logs the changes it makes to a database when it repairs name errors. Access saves the data in a table named AutoCorrect.log. You must close and reopen the current database for the specified option to take effect.

Filter lookup options for database name Database

The options in this section control several features:

  • The size of the value lists that appear for a given field in the Filter By Form window

  • Whether or not you can display values for indexed or nonindexed fields in the currently open database, and for a linked table in an external file

  • Whether or not the value lists appear in the controls in a form when you use Filter by Form

The more options you select, the more types of values you use in filtering operations. These options apply only to the currently open database.

  • Show list of values in    

    • Local indexed fields    Includes values from local indexed fields in the value lists that appear in the Filter by Form window. You must close and reopen the current database for the specified option to take effect.

    • Local nonindexed fields    Includes values from local nonindexed fields in the value lists that appear in the Filter by Form window. You must close and reopen the current database for the specified option to take effect.

    • ODBC fields    Includes values from tables to which you link by using an ODBC connection. You must close and reopen the current database for the specified option to take effect.

  • Don't display lists where more than this number of records read    Enter the maximum number of records that you want Access to read while it builds the value list for Filter by Form operations. A value list will not appear if the number of records required to complete a list exceeds the number you specify. All values lists will contain only unique values, even if their fields are not indexed. The default is 1000. You must close and reopen the current database for the specified option to take effect.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×