on Load

[MarMarMar]

Hi,
After some hours of frustration :banghead: I have to ask you for help

I want to hide PICTURE1 if text1.value=<0

When I add this code to a button it works:

if text1.value=<0 then
picture1.visible=false
end if

When I add this code to the ON LOAD event it doesnt work. So i guess the value of text1 (value of a subform) is loaded after the ON LOAD event.

Can someone help me to solve this problem?
Thanks.

 

[stopher]

I think you should use the On Current event.

 

[MarMarMar]

thanks for your replay. I had already tried that, but doesnt make a difference

 

[stopher]

Remove the .value or replace it with .text

 

[The_Doc_Man]

The question in my mind is, What is the format of [Text1] ?

If Text1 is interpreted as text, then

if text1.value=<0 then

should actually be

if Len([text1])=<0 then

or possibly

if Val([text1])=<0 then

Every now and then VBA will do a "silent" type-conversion on you without claiming a "mixed type" in the process. IF statements are one case where this happens. If the types of the comparands are wrong, it won't matter WHERE you put that IF statement. It won't work correctly anyplace you put it.