Required filed error messages

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Denis
    #1

    Required filed error messages

    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.firstna me' cannot contain a null valve because the
    required property for the field is set to True. Enter a value in this
    field

    Regards,

    Denis

    Tags: None
    • Allen Browne
      #2
      Re: Required filed error messages

      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" <denisphelan@gm ail.comwrote in message
      news:1171668745 .821904.279150@ v33g2000cwv.goo glegroups.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.firstna me' cannot contain a null valve because the
      required property for the field is set to True. Enter a value in this
      field

        Comment

        Previous template Next
        Working...