Show All

Hide All

To show the status of the current record in a form or datasheet, Microsoft Access displays the following symbols in the current record selector (record selector: A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.).

Symbol	Meaning
	This is the current record; the record has been saved as it appears.
	You are editing this record; changes to the record aren't yet saved.
	You are not currently editing this record in a batch transaction; changes to this record aren't yet saved. (Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.) only).
	This record is locked by another user; you can't edit it (Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) only).
	This is a new record that you can enter information in.
	This field is the primary key (primary key: One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.) field and contains unique data to identify the record (table Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) only).