By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Required filed error messages

P: n/a
Hi
I have a field called firstname in a table called table1. I have it
set as required in a form. How do I display a customized error message
rather than the standard one given by Access below

The field 'table1.firstname' cannot contain a null valve because the
required property for the field is set to True. Enter a value in this
field

Regards,

Denis

Feb 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
1. Open the table in design view.

2. Select the FirstName field.

3. Set its Required property to No (in the lower pane.)

4. Set its Validation Rule to:
Is Not Null

5. Type your custom message beside the Validation Text property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Denis" <de*********@gmail.comwrote in message
news:11**********************@v33g2000cwv.googlegr oups.com...
>
I have a field called firstname in a table called table1. I have it
set as required in a form. How do I display a customized error message
rather than the standard one given by Access below

The field 'table1.firstname' cannot contain a null valve because the
required property for the field is set to True. Enter a value in this
field
Feb 17 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.