Mandatory Data Fields

[Guest]

1) How I made form (data entry) all fields mandatory to fill the data. If any
one try to pass any field without filling the data, cursor not move to next
data field till not filled previous fields. Even clicking by mouse in next
field.

 

[Guest]

Hi Qazi,

Why should you care about the order in which a user fills out required fields?

The easiest method to require data entry is to simply set the Required
property to Yes in table design view for the field(s) that you need to have
filled in. However, I'd be concerned about requiring *every* field. You
might, after all, simply encourage your users to enter any old garbage just
to get around such strict rules on data entry.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________