Force user to enter data in access form

You need to go to the table design view of your database and click the field that you want to require your user that data needs to be entered, in the lower portion, click the required property box and select Yes. This should take in effect with your form as long as the form is connected with the db, which I think you have.

Hope this helps...:0)

In addition to going to the table and requiring an entry (which means it cannot be null), you can also check the form prior to submission and even trap the Null value and display a message box stating that the user needs to enter a value:

If IsNull Me![] Then
MsgBox
End if

You should still change the table-field attributes, but you can avoid unfriendly user error messages by trapping in code in an event procedure (on click, on update, etc.)

GOOD LUCK!

Since you want this ONLY on this particular form, you do not want to set the required entry properties at the table level, use the form level instead. On the Data tab for the control (textbox) for that field, set the following properties:

Validation Rule:
Len([NameOfThisControl])>0

Validation Text (your user message):
"You must enter a non-null value in this field"
or something else that communicates well with your user.

HTH,
Paul