Required Fields

G

Guest

I have some required fields in a form. At present, this is
setup in the table. The problem with this is; users get a
meaningless error message from Access when the new record
is saved back to the table. I'd like to change things so
the required fields are setup in the form so you can create
a more meaningful message. Any ideas on how to achieve this?

Regards,
Glenn
 
R

Rick B

In the "Validation Rule" put something like "Not Null" and enter whatever
message you desire in the "Validation Text".

Rick B


I have some required fields in a form. At present, this is
setup in the table. The problem with this is; users get a
meaningless error message from Access when the new record
is saved back to the table. I'd like to change things so
the required fields are setup in the form so you can create
a more meaningful message. Any ideas on how to achieve this?

Regards,
Glenn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
How do I clear a form? 0
Prevent printing if required field is blank 2
QBF & Query Malfunction 0
Change Required Field Property in Table 4
Testing for required data entry in form fields. 6
Copy previous record into form field 0

Top