Using IIF

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
 
T

Terry

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
 
F

fredg

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
 
Top