Re: Validation Rule

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tru (Tru_at_discussions.microsoft.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 02:41:04 -0800

Yeah I tried "Is Not Null" I still receive the standard error message. You
know the standard error message would not be that bad it it did not include
the table name and the table field name.

Jeff, thanx for taking time out to try and help me out.

"Jeff Boyce" wrote:

> Tru
>
> I suppose you could try Not Null (but I'm not sure if Access checks it's own
> internal table properties before checking the Validation rule ...
>
> Worth a test, no?
>
> Jeff Boyce
> <Access MVP>
>
>
> "Tru" <Tru@discussions.microsoft.com> wrote in message
> news:7DBF279C-B945-40FA-8DA1-43F7EFE61556@microsoft.com...
> > I want the field required but I do not like the error message Access
> displays
> > when the field is null. I just want to be able to display my own error
> > message in the validation text property. That's why I need to know what
> to
> > indicate in the Validation Rule to check for Null values.
> >
> > "Jeff Boyce" wrote:
> >
> > > Tru
> > >
> > > Not sure I understand the context of your reference to "the Validation
> Rule
> > > for a Null Value". When are you seeing the related error message?
> > >
> > > If you try to enter a new row/record and have not provided a value for a
> > > field that has its "Required" property set to "Yes", you have violated
> the
> > > definition of the table. A few obvious solutions are to make the field
> not
> > > required, put something in it, or also change the "Allow Zero-Length
> > > Strings" property to "Yes" (but this one adds other complications).
> > >
> > > --
> > > Good luck
> > >
> > > Jeff Boyce
> > > <Access MVP>
> > >
> > > "Tru" <Tru@discussions.microsoft.com> wrote in message
> > > news:EB4FBE25-81C4-43DA-A6A6-85BA00FC07A5@microsoft.com...
> > > > What is the Validation Rule for a Null Value in a table, because I am
> > > trying
> > > > to eliminate Access's confusing error message and create a simpler
> > > Validation
> > > > Text Error Message.
> > > > --
> > > > Thanx!
> > >
> > >
>
>

Relevant Pages

  • Re: Validation Rule
    ... I want the field required but I do not like the error message Access displays ... "Jeff Boyce" wrote: ... > Not sure I understand the context of your reference to "the Validation Rule ...
    (microsoft.public.access.tablesdbdesign)
  • Detecting a field which cause an error message
    ... I am learning how to create custom error messages. ... I know about the "OnError" event of the form, and knows how to replace the ... standard error message. ... I wish that Access will produce an error message saying something like "You ...
    (microsoft.public.access.forms)
  • Re: REQUIRED field(s) in FORMS
    ... >> I went into the TABLE for the field (BENEFICIARYNAME). ... > A Validation rule will not work here for a couple reasons. ... The built in error message for a missing Required field is pretty easy to ... > BeforeUpdate event of the form and display any message you want. ...
    (microsoft.public.access.gettingstarted)
  • Re: Validation Rule question
    ... you can set the Validation Rule of the field in table design ... The error message you describe makes sense if you consider that Access has ... so it is worth the effort to explicitly force a save before ... > the specified record." ...
    (microsoft.public.access.forms)
  • Re: Required Fields in a Form
    ... A safe alternative might be to use the Validation Rule of the table, ... In table design view, open the Properties box, and locate the ... > open a multitude of oppurtunities for data integrity to be violated. ... >> error message, if the required fields have not all been filled in. ...
    (microsoft.public.access.formscoding)