Zero

[Steve Pettitt]

I'm new to Access (previously used 'MS Works') so please post any reply in Idiot terms
Question:- In Excel and MS works I can tick a box to set any calculation fields which return a "zero" value to be 'blank'
My Form based on a Query which has numerous calculation fields which in some records (but not all) will return a '£0.00'. This makes may printed Form very messy

How can get these fields to be appear blank when the result of the calculation is zero?

 

[Gary Walter]

I'm new to Access (previously used 'MS Works') so please post any reply in Idiot terms.
Question:- In Excel and MS works I can tick a box to set any calculation fields

which return a "zero" value to be 'blank'.

My Form based on a Query which has numerous calculation fields which in some

records (but not all) will return a '£0.00'. This makes may printed Form very messy.

How can get these fields to be appear blank when the result of the calculation is

zero?

Hi Steve,

The simplest way would be be to select
the textbox in Design mode, choose
Conditional Formatting from dropdown
of top menu Format.

Define your condition as:

"Field Value Is" "Equal To" 0

click on the big "A" and set font color
to white (when the condition is met).

This will also work in a report,
which are typically used more for
print-outs than forms.

If you like the way your form is laid out,
in Design mode just select everything
(from top menu...Edit/Select All),
right-mouse click on your selected controls
and choose Copy (or just hit Ctl-C)...
start a new report and paste into new blank
report. Make any changes (for ex, you may have
some command buttons to delete, etc)
Save the report giving it a name.

Add a command button to your form
and in the wizard process, set it to open your
new report.

Then unset conditional formatting in form
so you see the zeroes, but when you print
report, you don't.

Pretty easy..eh.

Good luck,

Gary Walter

 

[Bill Crawford]

in the Criteria row of the Query, filter the '0.00's like this and return a
null

iif([Myfield]=0,null,[Myfield])

I'm new to Access (previously used 'MS Works') so please post any reply in Idiot terms.
Question:- In Excel and MS works I can tick a box to set any calculation

fields which return a "zero" value to be 'blank'.

My Form based on a Query which has numerous calculation fields which in

some records (but not all) will return a '£0.00'. This makes may printed
Form very messy.

How can get these fields to be appear blank when the result of the

calculation is zero?