Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Data Validation Rules

Discussion in 'Information Technology' started by Sandi, Jul 28, 2006.

  1. Sandi

    Sandi
    Expand Collapse
    Guest

    I have a data base that a lot of fields need to be required. I have set the
    Required field in the table to Yes, and I also want to set up Validation
    Rules and text so that they can not skip over fields. The only thing is I
    don't know what to set up inside my Validation Rule in the table to equal or
    read or anything. Any help would be appreciated.

    Thanks
    Sandi Gardner
     
  2. Loading...


  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    If you mean that you want to use a validation rule to ensure that the user
    does not leave the field blank, you can do it, but there is no point in
    doing it if the Required property is set. The Required property is enforced
    first, before the validation rule, so the validation rule will never be
    fired, and the user will never see your validation text.

    A validation rule to require the user to enter a value in a text field might
    look something like this ...

    Is Not Null And <>""

    Those are two double quotes with nothing between them at the end.

    --
    Brendan Reynolds
    Access MVP

    "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    news:5354A80D-466B-42B3-B8BB-218CB8C59502@microsoft.com...
    >I have a data base that a lot of fields need to be required. I have set
    >the
    > Required field in the table to Yes, and I also want to set up Validation
    > Rules and text so that they can not skip over fields. The only thing is I
    > don't know what to set up inside my Validation Rule in the table to equal
    > or
    > read or anything. Any help would be appreciated.
    >
    > Thanks
    > Sandi Gardner
     
  4. Sandi

    Sandi
    Expand Collapse
    Guest

    You're right. I took out the required field and changed it back to No and
    put in the Data Validation that you suggested and it works great. My one
    last question is what about date/time fields. Do I use the same expression
    for the text as before or will it be different for dates?
    --
    Sandi Gardner


    "Brendan Reynolds" wrote:

    > If you mean that you want to use a validation rule to ensure that the user
    > does not leave the field blank, you can do it, but there is no point in
    > doing it if the Required property is set. The Required property is enforced
    > first, before the validation rule, so the validation rule will never be
    > fired, and the user will never see your validation text.
    >
    > A validation rule to require the user to enter a value in a text field might
    > look something like this ...
    >
    > Is Not Null And <>""
    >
    > Those are two double quotes with nothing between them at the end.
    >
    > --
    > Brendan Reynolds
    > Access MVP
    >
    > "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    > news:5354A80D-466B-42B3-B8BB-218CB8C59502@microsoft.com...
    > >I have a data base that a lot of fields need to be required. I have set
    > >the
    > > Required field in the table to Yes, and I also want to set up Validation
    > > Rules and text so that they can not skip over fields. The only thing is I
    > > don't know what to set up inside my Validation Rule in the table to equal
    > > or
    > > read or anything. Any help would be appreciated.
    > >
    > > Thanks
    > > Sandi Gardner

    >
    >
    >
     
  5. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    You don't need the 'And <>""' part for date or number fields.

    --
    Brendan Reynolds
    Access MVP

    "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    news:D7449318-0045-4A3D-9FC6-92CD22FA0ABA@microsoft.com...
    > You're right. I took out the required field and changed it back to No and
    > put in the Data Validation that you suggested and it works great. My one
    > last question is what about date/time fields. Do I use the same
    > expression
    > for the text as before or will it be different for dates?
    > --
    > Sandi Gardner
    >
    >
    > "Brendan Reynolds" wrote:
    >
    >> If you mean that you want to use a validation rule to ensure that the
    >> user
    >> does not leave the field blank, you can do it, but there is no point in
    >> doing it if the Required property is set. The Required property is
    >> enforced
    >> first, before the validation rule, so the validation rule will never be
    >> fired, and the user will never see your validation text.
    >>
    >> A validation rule to require the user to enter a value in a text field
    >> might
    >> look something like this ...
    >>
    >> Is Not Null And <>""
    >>
    >> Those are two double quotes with nothing between them at the end.
    >>
    >> --
    >> Brendan Reynolds
    >> Access MVP
    >>
    >> "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    >> news:5354A80D-466B-42B3-B8BB-218CB8C59502@microsoft.com...
    >> >I have a data base that a lot of fields need to be required. I have set
    >> >the
    >> > Required field in the table to Yes, and I also want to set up
    >> > Validation
    >> > Rules and text so that they can not skip over fields. The only thing
    >> > is I
    >> > don't know what to set up inside my Validation Rule in the table to
    >> > equal
    >> > or
    >> > read or anything. Any help would be appreciated.
    >> >
    >> > Thanks
    >> > Sandi Gardner

    >>
    >>
    >>
     
  6. Sandi

    Sandi
    Expand Collapse
    Guest

    Thanks sooo much! Worked like a charm!!!!!
    --
    Sandi Gardner


    "Brendan Reynolds" wrote:

    >
    > You don't need the 'And <>""' part for date or number fields.
    >
    > --
    > Brendan Reynolds
    > Access MVP
    >
    > "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    > news:D7449318-0045-4A3D-9FC6-92CD22FA0ABA@microsoft.com...
    > > You're right. I took out the required field and changed it back to No and
    > > put in the Data Validation that you suggested and it works great. My one
    > > last question is what about date/time fields. Do I use the same
    > > expression
    > > for the text as before or will it be different for dates?
    > > --
    > > Sandi Gardner
    > >
    > >
    > > "Brendan Reynolds" wrote:
    > >
    > >> If you mean that you want to use a validation rule to ensure that the
    > >> user
    > >> does not leave the field blank, you can do it, but there is no point in
    > >> doing it if the Required property is set. The Required property is
    > >> enforced
    > >> first, before the validation rule, so the validation rule will never be
    > >> fired, and the user will never see your validation text.
    > >>
    > >> A validation rule to require the user to enter a value in a text field
    > >> might
    > >> look something like this ...
    > >>
    > >> Is Not Null And <>""
    > >>
    > >> Those are two double quotes with nothing between them at the end.
    > >>
    > >> --
    > >> Brendan Reynolds
    > >> Access MVP
    > >>
    > >> "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    > >> news:5354A80D-466B-42B3-B8BB-218CB8C59502@microsoft.com...
    > >> >I have a data base that a lot of fields need to be required. I have set
    > >> >the
    > >> > Required field in the table to Yes, and I also want to set up
    > >> > Validation
    > >> > Rules and text so that they can not skip over fields. The only thing
    > >> > is I
    > >> > don't know what to set up inside my Validation Rule in the table to
    > >> > equal
    > >> > or
    > >> > read or anything. Any help would be appreciated.
    > >> >
    > >> > Thanks
    > >> > Sandi Gardner
    > >>
    > >>
    > >>

    >
    >
    >
     

Share This Page