null text box
Thanks
-----Original Message-----
Hi FSt1
You are missing a )
if not (isnull(me.textbox) then
run this code and loop until lt.value = text box.value
end if
if not (isnull(me.textbox)) then
run this code and loop until lt.value = text box.value
end if
Thanks,
Greg
-----Original Message-----
hi,
I am having a little problem with a text box on a form.
I don't seem to know the correct syntax.
the text box may or may not have something in it.
the code runs, does a lot of things but if the text box
is
empty then the code is suppose to skip over part of the
code. if the text box has a number in it, then the code
should run the code associated with the text box.
in access the syntax would be:
if not (isnull(me.textbox) then
run this code and loop until lt.value = text
box.value
end if
with this if statement, if the text box is empty then
the
code would be skipped. if there is a number in the text
box, the code would run.
but in excel that don't seem to work. the code
associated
with the text box runs whether the text box is empty or
not. this is causing a overflow problem due to endless
run
away calculations leading to crash and burn.
Does anyone know what the correct syntax would be.
thanks in advance.
FSt1
.
.
|