DataEntry Property

Applies to

Form Object

You can use the DataEntry property to specify whether a bound form (form: An Access database object on which you place controls for taking actions or for entering, displaying, and editing data in fields.) opens to allow data entry only. The Data Entry property doesn't determine whether records can be added; it only determines whether existing records are displayed. Read/write Boolean.


expression Required. An expression that returns one of the objects in the Applies To list.


The DataEntry property uses the following settings.

Setting Visual Basic Description
Yes True The form opens showing only a blank record.
No False (Default) The form opens showing existing records.

 Note   You can set the DataEntry property by using a form's property sheet (property sheet: A pane that is used to view or modify the properties of various objects such as tables, queries, fields, forms, reports, data access pages, and controls.), a macro (macro: An action or set of actions that you can use to automate tasks.), or Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) code.

This property can be set in any view.

The DataEntry property has an effect only when the AllowAdditions property is set to Yes.

 Note   When the Data Mode argument of the OpenForm action is set, Microsoft Office Access 2007 will override a number of form property settings. If the Data Mode argument of the OpenForm action is set to Edit, Access will open the form with the following property settings:

  • AllowEdits — Yes
  • AllowDeletions — Yes
  • AllowAdditions — Yes
  • DataEntry — No

To prevent the OpenForm action from overriding any of these existing property settings, omit the Data Mode argument setting so that Access will use the property settings defined by the form.

Applies to:
Access 2007