Another IsNull Problem 1

[Akart]

Heya,

I have a problem as follows:

My Function checks to see if a field isnull and this works great.(Thanks to those who helped me with it)

Now that i know if my control is null, how can i make it null when it has a value in it. I tried the following and the data is removed from the control but the isnull function still returns false......

Forms!Customers_Main_Au.Customers_Search_AU!search2 = ""


What other method can i use to clear all the controls on a form without setting them to "" because that does not work =)


Regardos Akartos

 

[LearningSql]

Hi there --

Try seeting the control to null as in the following:

Forms!Customers_Main_Au.Customers_Search_AU!search2 = null

I believe this should work.

Cheers.

 

[Akart]

Akart punches the air... Hooray!

The simple ones always get me!

It worked, thanks!

Akart