Gee I can't suppress zeros on report details??

  • Thread starter Thread starter Jim Aga
  • Start date Start date
J

Jim Aga

I need blanks, nulls or space instead of zero's as they
appear on a report. I think the zeros need to be in the
query for math but just need to be seen as blanks on the
report.

There's no event available at the detail rpt field level,
just at the format, print and retreat levels. At these
levels I can ask if the field is 0 and it will tell me but
it won't let me "set a value to this field".

Is there a formatcommand or some other ideas out there?

Thanks in advance:
 
I need blanks, nulls or space instead of zero's as they
appear on a report. I think the zeros need to be in the
query for math but just need to be seen as blanks on the
report.

There's no event available at the detail rpt field level,
just at the format, print and retreat levels. At these
levels I can ask if the field is 0 and it will tell me but
it won't let me "set a value to this field".

Is there a formatcommand or some other ideas out there?

Thanks in advance:
Click to expand...

Set the format property of the control to:
#;-#;""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

detail line with zeros - suppress printing? 8
Suppress Zero values on the report 3
How to suppress blank yes/no fields 0
suppress report detail 1
suppress zeros in report 2
Suppress a section if the subtotals equals zero 1
Null in detail, but zero in totals 3
set sub report height 0

Back
Top