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

A textbox doesn't return null

if len(trim(textbox1.Text)) = 0 then
' textbox is empty

or

if Textbox1.Text = "" then

but the second would consider a textbox with just spaces as not empty (which
may or may not be your intent).



--
Regards,
Tom Ogilvy


"FSt1" wrote in 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

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

.

Thanks Tom.
-----Original Message-----
A textbox doesn't return null

if len(trim(textbox1.Text)) = 0 then
' textbox is empty

or

if Textbox1.Text = "" then

but the second would consider a textbox with just spaces
as not empty (which
may or may not be your intent).



--
Regards,
Tom Ogilvy


"FSt1" wrote in
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



.

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

.

.