Required filed error messages

[Denis]

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

[Allen Browne]

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