If field is Null

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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.
 
Back
Top