Reguiring Fields? 1

[Ryon]

I have probably 9 or 10 fields that cannot be left blank on an order entry screen. I was wondering what is the best way to do this. I know you can do this with the before update event. Is there a better way? I'm using Access 97. Thanks again.

Ryan

 

[ajdesalvo]

In the Table itself, for each of the required fields, set the Validation Rule to 'Is Not Null'. Add a message to the Validation Text like: "This field cannot be blank!"

Good luck!

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[Ryon]

Thanks Anthony for the fast response, I set the required field to "yes" and validation rule to "Is Not Null" and the Validation text to "This Field Cannot be left blank!".

I keep getting the Access default message of "the tblcallog.callnum required property is set to true. enter a value in this field.
how can I get it to display my message.
thanks Again

 

[ajdesalvo]

Set the Required property to No, this way the Validation Text will be displayed when the user tries to save the record.
Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[Ryon]

Thanks, Worked Great!!