Simplest and safest way is to open your table in design view, and set the
Required property for this field to Yes.
You could also use the BeforeUpdate event of the form (not the control) to
check if the text box IsNull().
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jain" <en*****@equilore.com> wrote in message
news:d7**********@news-02.connect.com.au...
How can I make it compulsory for data to be entered into a field in a
form. Eg it won't allow the user to close the form without filling in a
particular field. An error message appears saying "you must enter data
into ....field before closing form". The user would not necessarily tab
or enter this field so an after update etc would not work.