if statement using null

[swarv]

All,

I have the following If statement:

If Forms!frm_homepage!new2008hols = Null Then

It doesn't seem to work as it doesn't understand Null. If I hover the mouse over it, it comes back as Null but for some reason doesn't work.

Thanks
Martin

 

[namliam]

Is null is something you use in a query (4GL)
in programming (3GL) you cannot do this... Use Isnull(YourField) instead.

Happy coding

 

[swarv]

great thanks.