basic question.. if value is not null

[antonyx]

hi.. just a quick question...

i want my script to run if the value of txtjobdate is not empty..

im using this at the moment

If Me.txtjobdate.Value <> "" Then

it works when the textbox is not null.. but when it is null.. rather than ignore the script it tells me Run time error 94, invalid use of Null

so what is the best way to declare if a textbox is not null?

 

[Bat17]

If Me.txtjobdate & "" <> "" Then

should sort it

Peter

 

[antonyx]

cheers.. that did sort it