Don't want zero vaules to print

[e_lady]

I am filling in preprinted forms with Access. There are fields which are calculated in a query. Those fields which are zero in value appear in my form, which is OK. But, they do not need to be printed on my report. How can I have my report do this?

 

[ed333]

Change the criteria for the query that the report is based on to select nonzero values for that field.

For example, if your field was called "MyField", then in the design view for the query change the line labeled "Criteria" under MyField to read "<>0"
(don't use quotes, though!)

Hope this helps,
Ed

 

[uncle-lai]

There are 2 ways (as far as I know, as a novice Access addict) to hide 0 values in reports:

1. Using the Text Box's Format Property -
eg.: $#,##0.00;($#,##0.00); 0 [White];"Null"
for full explanation search Access Help for
Format Property — Number and Currency Data Types


2. Use VB code in the OnFormat event of the Section in which your Text Box resides:
MyTextBox.Visible = (MyTextBox > 0)

I use the 2nd method because I can see at a glance all Text Boxes I have hidden when they are 0.

Peter

 

[e_lady]

Thank you both! I was able to use all three methods in my reporting/form filling.