input masks

[paulonawall]

I used an input mask "\$####.##" in a currency field but I
get "$0.00" when I leave it blank. How do I make it blank
when there's no data input?

 

[Bruce M. Thompson]

I used an input mask "\$####.##" in a currency field but I

get "$0.00" when I leave it blank. How do I make it blank
when there's no data input?

You can remove the 0 (zero) from the field's "Default Value" property at the
table level, but you will need to address Nulls in any code to avoid runtime
errors.