Validation Rules and Text not transferring

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have placed validation rules and text in several fields in many tables and have made forms with those tables. My problem is the validation rules and text are not transferring from the table fields to the form fields, yet all the other field properties have transferred. Does anyone know why this is? I was thinking there might be an option in the database properties that controls this but I can't find anything

Thank you
Steve
 
Steve said:
I have placed validation rules and text in several fields in many
tables and have made forms with those tables. My problem is the
validation rules and text are not transferring from the table fields
to the form fields, yet all the other field properties have
transferred. Does anyone know why this is? I was thinking there
might be an option in the database properties that controls this but
I can't find anything.

Those properties don't have to be transferred from the table to the
form, because they are enforced by the database engine itself. You can
use the Validation Rule/Text properties on the form to apply other
requirements that are *not* enforced by the database engine, but only by
the form; however, the validation rules you've specified in the table
definitions will still be applied.
 

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

validation rule 1
Validate a Date 1
Validation Rule/Text 1
Validation Rule For only one Field 2
Validation Rule problem 6
Validation Rule On Form 2
Validation Rule in Access 2007 3
Validation Rule assistance 0

Back
Top