Re: newbie question II - Empty field in a form. - Article 231 - go-pugleaf

Article View: comp.databases.ms-access

Article #231

Back to comp.databases.ms-access Previous Next

Re: newbie question II - Empty field in a form.

#231

From: Fred Colman
Date: Fri, 25 May 2001 09:39

28 lines
2056 bytes

You may want to try
if (isnull(Me!field) or Me!field="") then...

You probably want to put this in the before update event.

hth,
Fred

"Henning Lang" <hlang@myrealbox.com> wrote in message
news:YbpP6.8$rB3.559@news010.worldonline.dk...
> As parts of a validation rule, I would like to test whether a field in a
> form is empty. I've tried with:
>
> a) if len(me!field ) then
> b) if isnull(me!field)
>
> but neither works. So my question is what have I done wrong and what is
the
> correct method. Also I would like on which event I should place the code.
It
> should be validated when the user tabs out of the field
>
>
> Henning Lang
> hlang@myrealbox.com
>
>
>

Technical Details

Message-ID: <ELpP6.31360$BN6.1675504@newsread1.prod.itd.earthlink.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed1.earthlink.net!newsfeed.earthlink.net!newsmaster1.prod.itd.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail

References: <YbpP6.8$rB3.559@news010.worldonline.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,d97964246c28cab4
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11387c,d97964246c28cab4
X-Google-Attributes: gid11387c,public
X-Google-ArrivalTime: 2001-05-25 02:39:51 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed1.earthlink.net!newsfeed.earthlink.net!newsmaster1.prod.itd.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail
From: "Fred Colman" <fred@reddelicious.com>
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access
References: <YbpP6.8$rB3.559@news010.worldonline.dk>
Subject: Re: newbie question II - Empty field in a form.
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <ELpP6.31360$BN6.1675504@newsread1.prod.itd.earthlink.net>
Date: Fri, 25 May 2001 09:39:48 GMT
NNTP-Posting-Host: 64.81.246.101
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread1.prod.itd.earthlink.net 990783588 64.81.246.101 (Fri, 25 May 2001 02:39:48 PDT)
NNTP-Posting-Date: Fri, 25 May 2001 02:39:48 PDT
Organization: EarthLink Inc. -- http://www.EarthLink.net
X-Received-Date: Fri, 25 May 2001 02:38:03 PDT (newsmaster1.prod.itd.earthlink.net)

Reply to Parent Message