If field is Null

[Rob]

Hi Everyone,

Certain controls on my form are dependant on other sections of the form to
be able to show a value.

Until these other controls have been selected they display "Error"

How can I code an If txtbx = Null or something to stop the word "Error"
showing up.

Thanks a lot this will help me tidy up the page a lot.

Rob

 

[Wayne Morgan]

Try the Nz function to return a value other than Null.

Example Control Source:
= Nz(txtMyTotals, 0) * 3

The Nz function will work in VBA code also.