Currency - making it empty without £0.00

[evilcowstare via AccessMonster.com]

Hi I have several text boxes that are for currency.
On a report and in the form these all automatically display £0.00 is there
anyway to set it up so that the field is empty until someone enteres an
amount?

Thank You

 

[Al Campagna]

evil,
You should be able to format that control on your report.
Formatting a control has 4 parts (positive, negative, zero, null)
So, for example... this format
+£ #,000.00;-£ #,000.00; "Zero";"Null"
would show positive numbers as +£ 3,421.56
negatives as -£ 3,421.56
zeroes as "Zero"
and nulls as "Nulls"

In your case, the Zero and Null settings might be "" and ""

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[evilcowstare via AccessMonster.com]

Ok it is just me but to be honest you just completely confused me lol
So I need to put +£ #,000.00;-£ #,000.00; "";""
Where do I put that, where is the format control for a report?
I know of the format tabe but cant see anything in it that suggests it should
go in it.
Sorry never ven tried this before

Thank You

 

[missinglinq via AccessMonster.com]

All you have to do is go into Design View for your table then select the
field in question. Under Default Value you'll see a zero; hilite the zero and
hit Delete. Save the Query on exiting.

 

[Al Campagna]

evil,
In report design mode, place
+£ #,000.00;-£ #,000.00; "";""
in the Format property for your field. Also set the Decimal Places to 2
Read up in Help under "Format Property - Number and Currency Data Types"
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[missinglinq via AccessMonster.com]

Why would you want to that when you can simply make the default value in the
table blank? And how does formatting the field in the report affect the
field's appearance in the form?

 

[Al Campagna]

I have found it best to always Default to 0 in any numeric field, particularly monetary
fields, rather than an empty or null.
Even when a user deletes a value, I set it back to zero.
Calculations will fail when encountering empty or null values, and NZ handling...

If a control is formatted to display "" (blank) for a zero value, that value is still a
zero as far as calculations are concerened, but they display... as wanted... by the OP.
This would apply to both form and report controls.
As soon as someone enters an non zero amount the value will dsplay in the format the OP
wanted...
£ 5,123.58

Personally, I never hide zeroes, as requested by the OP... zero is a legitimate value, and
should be displayed as such.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[missinglinq via AccessMonster.com]

"zero is a legitimate value, and should be displayed as such." Maybe in your
world, but not necessarily in all universes! I, for instance, have an app
where the equipment hours reading is displayed for the Current Visit and
Previous Visit. On the initial visit the Current reading is entered. On the
second visit, when the Current reading is entered, the Current reading from
the first visit becomes the Prevous reading. I don't want the Previous Visit
reading to display a zero after the initial visit, because that's not correct!


If you had a field for, say, Donation Amount, you might not want it to
display $0 when, in fact, a value simply hadn't been entered as yet!

I try to always remember that the needs/rules of business of my industry are
not necessarily those of your industry or of any poster's industry. I
usually assume the OP knows best what he/she need.

 

[Al Campagna]

missinglinq,
I'm not sure what part of "Personally, I never hide zeros." you interpreted as an
implicit establishment of a "mandate."
Nor, do I see... anywhere in my post/s... that I discouraged the OP from NOT
"displaying" zero values... pertaining to either an entered... or calculated... value.

I try to always remember that the needs/rules of business of my industry are
not necessarily those of your industry or of any poster's industry.

That's just condescending, and rude... it implies that I don't.

Also...If you have a moment, please check out Section 8-iii of the Access Netiquette,
posted at
http://www.mvps.org/access/netiquette.htm

--
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."