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

Article View: comp.databases.ms-access

Article #232

Back to comp.databases.ms-access Previous Next

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

#232

From: Jim Andersen
Date: Fri, 25 May 2001 14:16

40 lines
2247 bytes

if len(me!field & "")=0

this way it checks for null and for zero-length string

and you could put it in the fields OnExit.

Jim
"Fred Colman" <fred@reddelicious.com> skrev i en meddelelse
news:ELpP6.31360$BN6.1675504@newsread1.prod.itd.earthlink.net...
> 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: <9elpeh$1nn4$1@news.cybercity.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!colt.net!news.tele.dk!212.242.40.196!news.cybercity.dk!not-for-mail

References: <YbpP6.8$rB3.559@news010.worldonline.dk> <ELpP6.31360$BN6.1675504@newsread1.prod.itd.earthlink.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11387c,d97964246c28cab4
X-Google-Attributes: gid11387c,public
X-Google-Thread: ff0ac,d97964246c28cab4
X-Google-Attributes: gidff0ac,public
X-Google-ArrivalTime: 2001-05-25 07:15:49 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!colt.net!news.tele.dk!212.242.40.196!news.cybercity.dk!not-for-mail
From: "Jim Andersen" <jim@officeconsult.dk>
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access
Subject: Re: newbie question II - Empty field in a form.
Date: Fri, 25 May 2001 16:16:59 +0200
Organization: OfficeConsult
Lines: 42
Message-ID: <9elpeh$1nn4$1@news.cybercity.dk>
References: <YbpP6.8$rB3.559@news010.worldonline.dk> <ELpP6.31360$BN6.1675504@newsread1.prod.itd.earthlink.net>
NNTP-Posting-Host: port62.ds1-taa.adsl.cybercity.dk
X-Trace: news.cybercity.dk 990800145 57060 212.242.61.193 (25 May 2001 14:15:45 GMT)
X-Complaints-To: abuse@cybercity.dk
NNTP-Posting-Date: Fri, 25 May 2001 14:15:45 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

Reply to Parent Message