Function

[Eric Cole]

I want to design a function which is basically the
opposite of Nz(). I want a field to appear blank if it is
equal to zero. Any ideas?

 

[fredg]

I want to design a function which is basically the
opposite of Nz(). I want a field to appear blank if it is
equal to zero. Any ideas?

Set the Format property of the control to:
#;-#;""

See Access help...
Format property + Number and Currency datatype

 

[Eric Cole]

Thanks for your response

-----Original Message-----


Set the Format property of the control to:
#;-#;""

See Access help...
Format property + Number and Currency datatype
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.