Advanced category (Access Options)

Editing

  • Move after enter    

    • Don't move    Keeps the cursor in the current field after you press ENTER.

    • Next field    Moves the cursor to the next field after you press ENTER. By default, the next field is located either to the right or to the left of the current field, depending on how you set your text direction.

    • Next record    Moves the cursor to the current field of the next record after you press ENTER. The next record is the record directly below the current record.

  • Behavior entering field    

    The options in this section change the behavior of the ENTER, TAB, and arrow keys when you use them to move the cursor from field to field in forms and datasheets.

    • Select entire field    Selects the entire field when the cursor enters that field.

    • Go to start of field    Moves to the start of the field when the cursor enters that field.

    • Go to end of field    Moves to the end of the field when the cursor enters that field.

  • Arrow key behavior    

    • Next field    Moves the cursor to the next field after you press the RIGHT or LEFT arrow keys. To move the cursor within the characters in a selected field, press F2.

    • Next character    Moves the cursor to the next or previous character in a field after you press the RIGHT or LEFT arrow keys.

    • Cursor stops at first/last field    Prevents the LEFT and RIGHT arrow keys from moving the cursor from the first or last field to the previous or next record.

  • Default find/replace behavior

    The options in this section control the behavior of find and find/replace operations in Microsoft Office Access 2007, and apply to Office Access 2007 globally.

    • Fast search    Searches the current field and matches the whole field to the search string.

    • General search    Searches all fields and matches any part of a field.

    • Start of field search    Searches the current field and matches the starting characters in the field.

  • Confirm

    • Record changes    Displays a confirmation message whenever you change a record.

    • Document deletions    Displays a confirmation message whenever you delete a database object.

    • Action queries    Displays a confirmation message whenever you run an append, update, delete, or make table action query against an Access database.

  • Default direction

    • Left-to-right    Sets new objects to display in a left-to-right direction familiar to English and European language users. For example, this setting displays the first field in a table starting in the leftmost column and adds new fields to the right of the column, and places the record number box and navigation buttons in Datasheet view in the lower-left corner.

    • Right-to-left    Sets new objects to display in a right-to-left direction familiar to Middle Eastern language users. For example, this setting displays the first field in a table starting in the rightmost column and adds new fields to the left of the column, and places the record number box and navigation buttons in table Datasheet view in the lower-right corner.

  • General alignment

    • Interface mode    Makes the character display consistent with the user interface language in effect. For example, when the user interface language is a left-to-right language (such as English), characters are aligned left.

    • Text mode    Aligns display text according to the direction of the first language-specific character. For example, if the first strong character (not a numeral or special character) is in English, text will be aligned left.

  • Cursor movement

    • Logical    Sets the cursor movement to progress within bidirectional text according to the direction of the language encountered. For example, when using the arrow keys to move through Arabic and then English text in the same sentence, the insertion point moves in a right-to-left direction through the Arabic text and then starts at the leftmost character of the English word and continues its movement in a left-to-right direction.

    • Visual    Sets cursor movement to progress within bidirectional text by moving to the next visually adjacent character. For example, when using the arrow keys to move from right to left through Arabic and then English text in the same sentence, the insertion point moves in a right-to-left direction through the Arabic text and then continues at the rightmost character of the English word and progresses in a right-to-left direction.

    • Datasheet IME controlSelect to have the East Asian IME Mode set to "No Control" when entering data in table datasheet.

    • Use Hijri CalendarBases the underlying date reference on the Islamic lunar calendar. If not selected, the database uses the Gregorian calendar. Access recommends choosing a calendar type when you first create a database, and then never changing that setting.

Display

  • Show this number of Recent Documents    Set or change the number of recently used files that appear in the Open Recent Database pane on the Getting Started with Microsoft Office Access page, and in the Recent Documents list that appears when you click the Microsoft Office Button Office button image .

  • Status bar    Displays the status bar at the bottom of the Access window.

  • Show animations    Turns on animated features, such as the animated insertion of new columns into datasheets.

  • Show Smart Tags on Datasheets    Displays Smart Tags on your datasheets.

  • Show Smart Tags on Forms and Reports    Shows Smart Tags on forms and reports.

  • Show in Macro Design    

    • Names column    Displays the Macro Name column in the macro designer. You can also show or hide this column by clicking Macro Names in the Show/Hide group of the Design tab. Note that if you turn off this option, but you then open a macro (in Design view) that contains macro names, the hidden column will be visible. This setting applies to all databases, but you can use the Macro Names command to turn off this setting for the current macro.

    • Conditions column    Displays the Conditions command in the macro designer. You can also show or hide this column by clicking Conditions in the Show/Hide group of the Design tab. Note that if you turn off this option, but you then open a macro (in Design view) that contains one or more conditions, the hidden column will be visible. This setting applies to all databases, but you can use the Conditions command to turn off this setting for the current macro.

Printing

  • Left margin    Changes the default left margin for datasheets, modules, and new forms and reports. You can use values ranging from zero to the width or height of a printed page. To change the margins in existing forms and reports, click the Microsoft Office Button Office button image , point to Print, click Print, and then click Setup in the Print dialog box.

  • Right margin    Changes the default right margin for datasheets, modules, and new forms and reports. You can use values ranging from zero to the width or height of a printed page. To change the margins in existing forms and reports, click the Microsoft Office Button Office button image and use the Page Setup command.

  • Top margin    Changes the default top margin for datasheets, modules, and new forms and reports. You can use values ranging from zero to the width or height of a printed page. To change the margins in existing forms and reports, click the Microsoft Office Button Office button image and use the Page Setup command.

  • Bottom margin    Changes the default bottom margin for datasheets, modules, and new forms and reports. You can use values ranging from zero to the width or height of a printed page. To change the margins in existing forms and reports, click the Microsoft Office Button Office button image and use the Page Setup command.

General

  • Show add-in user interface errors    If you are a developer, select this check box to show errors in your user interface customization code, or clear this check box to hide the errors.

  • Provide feedback with sound    Plays available sounds that are associated with Microsoft Office Professional 2007 program events, such as opening, saving, and printing files, and displaying error messages. Sounds that are assigned to different events can be changed in the Sounds Properties dialog box in Windows Control Panel. If you select or clear the Provide feedback with sound check box in one Office program, it is also turned on or off for all other Office programs. To change the sound that is associated with an event, open the Sounds folder in Windows Control Panel. Your computer must have a sound card to play most sounds.

  • Use four-digit year formatting    

    • This database    Sets the default year format for the currently open database to four digits (yyyy).

      Note: This setting supersedes the All databases setting for the currently open database.

    • All databases    Sets the default year format for all databases to four digits (yyyy).

  • Web Options    Displays the Web Options dialog box. Use the dialog box to set Web options for database objects. You can set the appearance of hyperlinks and followed hyperlinks in tables, queries, forms, and reports.

Advanced

  • Open last used database when Access starts    When this is selected, Access opens the last used database instead of displaying the Getting Started with Microsoft Office Access page.

  • Default open mode

    • Shared    Opens an existing database for shared use. This is the default setting.

    • Exclusive    Opens an existing database for exclusive use by a single user.

  • Default record locking

    • No locks    Leaves records open for editing.

    • All records    Locks all records in the open form or datasheet, and also locks records in any underlying tables. Records remain locked for as long as you have the objects open.

    • Edited record    Locks only the record you are editing.

  • Open databases by using record-level locking    Makes record-level locking the default for the currently open database. Clearing this check box makes page-level locking the default for the open database. The choice you make applies to data in forms, datasheets, and code that uses a recordset object to loop through records. This option does not apply to action queries or code that performs bulk operations by using SQL statements.

  • OLE/DDE timeout (sec)    Controls the interval after which Access retries a failed OLE or DDE attempt. Valid values: 0-300. Default value: 30.

  • Refresh interval (sec)    The number of seconds after which Access automatically updates records in Datasheet or Form views. Valid values: 0-32,766. Default value: 60. A value of 0 prevents updates.

  • Number of update retries    The number of times Access tries to save a changed record that is locked by another user. Valid values: 0-10. Default value: 2.

  • ODBC refresh interval (sec)    The interval after which Access automatically refreshes data gathered through an ODBC connection. This setting takes effect only when the database is shared on a network. Valid values: 0-32,766. Default value: 1500. A value of zero prevents updates.

  • Update retry interval (msec)    The number of milliseconds after which Access tries to save a changed record that is locked by another user. Valid values: 0-1,000. Default value: 250.

  • DDE operations

    • Ignore DDE requests    Access ignores DDE requests from other applications.

    • Enable DDE refresh    Enables Access to update DDE links at the interval specified in the Refresh interval (sec) box.

  • Command-line arguments    Enter arguments that run when you start Access or open an Access database.

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!

×