Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Applies to

Form Object

You can use the DataEntry property to specify whether a bound form 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.DataEntry

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

Remarks

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, a macro, or Visual Basic for Applications (VBA) 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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×