I want Currency field blank unless amount is entered

[Dave Eliot]

I have three Currency fields. Right now they all say "$0.00"
I would like to have them completely empty unless an amount is entered.
Can this be done?

Thanks.

 

[Brendan Reynolds]

I have three Currency fields. Right now they all say "$0.00"
I would like to have them completely empty unless an amount is entered.
Can this be done?

Thanks.

In table design view, select the field(s) in question, and delete the 0 from
the Default Value property. Leave it blank instead.

 

[Dave Eliot]

Thanks so much.

Yes, it works; however, I have a calculated field (based on sum of those
fields) that doesn't calculate when I do that. So it's back to "$0.00" ?

 

[Steve]

Put the following expression in the control source property of your
calculated field:
=NZ(Field1,0) + NZ(Field2,0) + NZ(Field3,0)

The NZ Function says if the field has a value, use it, otherwise, use the
value on the right side of the comma.

Use your actual textbox names for Field1, Field2 and Field3.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Ken Snell \(MVP\)]

Change the Format property of the field (in design view of the table) to
this:

$#,##0.00;-$#,##0.00;"";""

 

[Dave Eliot]

Thanks so much! Really appreciate your help.

Put the following expression in the control source property of your
calculated field:
=NZ(Field1,0) + NZ(Field2,0) + NZ(Field3,0)

The NZ Function says if the field has a value, use it, otherwise, use the
value on the right side of the comma.

Use your actual textbox names for Field1, Field2 and Field3.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)