conditional checkbox?

[Audrey]

I am trying to use a checkbox control on a report to
denote when a cost code equals a specific value. I have
tried setting the control source of the checkbox to

= True If [ASUP Monthly]![EMPL CC #] = 62178
(Main Table) (Cost Center)

None of the checkboxes on the report enable with this
code. Any ideas?
Thanks!

 

[Anne Orcutt]

-----Original Message-----
I am trying to use a checkbox control on a report to
denote when a cost code equals a specific value. I have
tried setting the control source of the checkbox to

= True If [ASUP Monthly]![EMPL CC #] = 62178
(Main Table) (Cost Center)

None of the checkboxes on the report enable with this
code. Any ideas?
Thanks!

Open your report in design view.

Put your cursor on the checkbox.

Open the Properties Dialog Box for the checkbox.
Select the Data Tab.
On the the Control Source line type the following:

=iif([ASUP Monthly]![EMPL CC #] = 62178, True, False)

You need to learn about the IIF FUNCTION - it is easily
found in the Access Help Index.