default value

  • Thread starter Thread starter TLC
  • Start date Start date
T

TLC

I am refreshing a subform that will not list $0.00 in the
amount field if the new record is empty. I've tried using
the default value on the form AND the table to no avail.
HELP!

T
 
TLC,
Make the DefaultValue property for the field = 0.
Check the Format property for that field on your form
$#.00;-$#.00;$0.00;$0.00
will display $5.00 for positive numbers, -$5.00 for negative numbers, $0.00
for zero values, and $0.00 for Null values.
hth
Al Camp
 
Try...
$#,###.00;-$#,###.00;$0.00;$0.00

Check out Help on Format property... you'll be using it a lot.
hth
Al Camp
 
Back
Top