How do I print a report without showing any zero fields

  • Thread starter DURASEAL ADMINISTRATOR
  • Start date
D

DURASEAL ADMINISTRATOR

i HAVE A FORM THAT HAS CALUCATIONS THAT IN ORDER TO TOTAL, SOME INSTANCES
REQUIRRES A "0" BE ENTERED WHEN THERE IS NO VALLUE IN ORDER FOR FORM TO
TOTAL. I DO NOT WANT THIS "0" VALUE TO PRINT ON MY REPORT, HOW DO I FORMAT
REPORT TO ONLY PRINT WHEN THERE IS A NUMERIC VALUE NOT WHEN "0"
 
R

Rick B

Exclude them from the data source (the query).

Your report should be based on a query. Just put criteria in to say >0 or
not null.

Rick B.
 
D

Duane Hookom

Please find and turn off your CAPS LOCK. Use your shift key.

Do you want to filter out records with 0 or do you want to display a blank
or nothing where there is a value of 0? If you want to simply adjust the
formatting, use the format property. Check Help on formatting numbers to see
how to do this.
 
D

DURASEAL ADMINISTRATOR

I want to display a blank or nothing on the report, when the field on the
form is 0
 
D

Duane Hookom

Where does your value come from? Is it in a table/query or calculated only
on the form?

Did you check Help on format settings for numeric values?
 
B

BabyATX13 via AccessMonster.com

You will need to write the code in VBA for that.


(example)
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If TotalPcs.Value = 0 Then
TotalPcs.Visible = False
PcsLBL.Visible = False
MailingCost.Visible = False
Else
TotalPcs.Visible = True
PcsLBL.Visible = True
MailingCost.Visible = True
End If

end sub
 
D

DURASEAL ADMINISTRATOR

The value is on the form only, i have three fields I enter dollar amounts in,
which calucates a total, the expression in the form for the total calculation
requires a number in each of the three fields in order to total, so if there
is no number for the field i must enter a zero to have it calculate a total.
I do not want these zero entries to show on my report which is set to print
automatically from this form.
 
B

BabyATX13 via AccessMonster.com

DURASEAL,
did you try my earlier suggestion?


see below, it should work for what you need
KB
 
D

Duane Hookom

Sometimes I feel like I am talking to either my kids who don't listen or to
my dad who doesn't hear well. I try to be nice to them all so again I will
ask:

Did you check Help on format settings for numeric values?
 
D

DURASEAL ADMINISTRATOR

I am sorry, I seem like such an idiot to you, I am trying, and yes I did
check Help on format settings for numeric values
 
D

Duane Hookom

Do I have to ask if you found anything useful to solve your problem or if
you understand what you found or if you are still struggling with display
zero values as blanks?
 
Top