Header Text

[Guest]

I have a report that has a Yes/No check off box called Active/Inactive. What
I would like is in the Header for "Active Contact" or "InActive Contact" to
print depending on if this check box is marked or not. I am new to
access...how would I do this?

 

[Duane Hookom]

Add a text box with a control source of:
=IIf([Active/Inactive]=True,"Active Contact", "InActive Contact")
This assumes that checked means Active and not Inactive.

Make sure the name of the control is not a field name.

 

[Guest]

It worked...thank you very much.
--
Thank, Lori

Add a text box with a control source of:
=IIf([Active/Inactive]=True,"Active Contact", "InActive Contact")
This assumes that checked means Active and not Inactive.

Make sure the name of the control is not a field name.

--
Duane Hookom
MS Access MVP
--

I have a report that has a Yes/No check off box called Active/Inactive.
What
I would like is in the Header for "Active Contact" or "InActive Contact"
to
print depending on if this check box is marked or not. I am new to
access...how would I do this?