conditional checkbox?

  • Thread starter Thread starter Audrey
  • Start date Start date
A

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!
 
-----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!
Click to expand...

Open your report in design view.
Put your cursor on the checkbox.
Click to expand...
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.
 
Back
Top