Syntax problem with IIF statement

[supracharger]

Could anybody tell me why this Syntax doesn't work (In Red is the problem):
=IIf([3 Price]="$0.00","",[3 Price])

How would I re-write that so it would work?



By Default [3 Price] displays $0.00, and I want it to display nothing (Ex. "")

Thanx for your help,
A.

[pbaldy]

There's nothing wrong with the part in red, and you haven't said what the problem is. My guess is you don't want the quotes around the 0.

[RuralGuy]

[3 Price] a control or a field name, or both? Is it a numeric field or string field?

[supracharger]

I'm not quite sure what you are saying but [3 Price] is a Field name in a Table (Currency).
A>

[RuralGuy]

As Paul said, try: =IIf([3 Price]=0,"",[3 Price])

FWI: A Currency field is a special type of field and the $ is not stored.

[supracharger]

My mistake I got it.

=IIf([3 Price]=0,"",[3 Price])

But now it won't display Currency; it shows (Ex. 130), and I want it to show (Ex. $130.00).

How do I get it to display Currency?
A>

[RuralGuy]

To what do you have the Format property set? Try Currency.

[pbaldy]

The double quotes is causing the field to be treated as text. You can use the Format function in the else clause, but what I would do is use the format property of the textbox. It can have 4 parts: positive, negative, null and zls.

[pbaldy]

And I should have clarified, that would mean taking out this formula and just using the field.

[supracharger]

I got it.
Thanx so much for you help,
A.

[RuralGuy]

What did you end up using?

[supracharger]

The I used "Format", I just wasn't thinking.
A.

[RuralGuy]

Thanks for sharing.