hide checkbox on report

[deb]

I was wondering how I can have a check box show up on a
report only if the answer is yes....otherwise I would
prefer it to not show up at all.

Also, can I have it displayed as a "b" other than a check
box?

--Deb

 

[Howard Brody]

I wouldn't worry about it in the Report. Add a field to
the source query, based on the CheckBox. If the CheckBox
is Yes, populate your letter "b" into the field, otherwise
leave it blank. Then use the new field on your report
instead of the CheckBox.

Hope this helps!

Howard Brody

 

[fredg]

I was wondering how I can have a check box show up on a
report only if the answer is yes....otherwise I would
prefer it to not show up at all.

Also, can I have it displayed as a "b" other than a check
box?

--Deb

Deb,
Instead of using the actual check box field in your report,
use a text control instead.
Add a new text control to the report.
Set it's Control Source to the CheckBox field.
Then write, in the control's Format Property line:
;"b";

The letter b will appear only if the check box is true.
Nothing will appear otherwise.