Header Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
It worked...thank you very much.
--
Thank, Lori


Duane Hookom said:
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
--

Lori said:
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?
Click to expand...
Click to expand...
 
Back
Top