Using IIF

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

hi all,

i am trying to use IIF to make a field visible if the check box is true.

i have tried a few variations but no luck.

any suggestions ?

thx
 
Josef,

You don't say where this field is, I will assume it is in
a report (as this is a reports group). In design view
select the control (field?) you want made
visible/invisible and use the conditional formating
(Format - Contional formatting) to set the text colour
from white to black (for example). I think this
functionality is available from Access 2000 onwards. If
you are running an older version post back with details
(there are other ways to skin this cat).

HTH,

Terry
 
hi all,

i am trying to use IIF to make a field visible if the check box is true.

i have tried a few variations but no luck.

any suggestions ?

thx
Click to expand...

You don't need IIf.
In a Report?
In the Detail Section?
Code the Report Detail Section's Format event:
[FieldName].Visible = [CheckBoxName] = -1
 
Back
Top