Required Fields

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top