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:
#;-#;""
 
Back
Top