form to insert data with compulsory fields

[halx]

Hello,

I have a form whose control source is a table (the form is used to insert data in the table).
Suppose I want to oblige the user of the form to insert data in the field "txtName" (that is: the user cannot go to the next record or exit the form if txtName is null).
What can I do ?

Thanks

Alex

 

[LittleSmudge]

In the DESIGN of the TABLE that the form is bound to make the
REQUIRED property Yes
and the
ALLOW ZERO LENGTH Property No

Then Access will not allow the user to leave the current record without data in that field. ( This will work if the user is using your form & will also work if the user tries to edit the table directly. )


QED.

G LS

 

[halx]

OK. Thank you very much.


Alex