Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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. OP
    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. OP
    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. OP
    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. OP
    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
    > >>
    > >>
    > >>

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page