newbie question II - Empty field in a form. - Thread - go-pugleaf

Thread View: comp.databases.ms-access

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Henning Lang Fri, 25 May 2001 09:01

newbie question II - Empty field in a form.

#230

Author: Henning Lang
Date: Fri, 25 May 2001 09:01

13 lines
1655 bytes

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

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

#231

Author: 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
>
>
>

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

#232

Author: 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
> >
> >
> >
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads