Creating a Checkbox to indicate data

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

Guest

Hi
I would like to create a Checkbox on a form which will indicate whether
another field (not shown on the form) contains any data. Could you help me
with the code please?
Many thanks
 
Dave,
Place a checkbox on the form (ex name [HasData]) and give it this
ControlSource...
=IIF(Not IsNull(YourHiddenField) = True, False)
hth
Al Camp
 
Thanks - it worked!

I've now got an enabled white check box for each hidden field with data. The
others are greyed out. That's fine except can I get an x in the white enabled
checkboxes?
Thanks

AlCamp said:
Dave,
Place a checkbox on the form (ex name [HasData]) and give it this
ControlSource...
=IIF(Not IsNull(YourHiddenField) = True, False)
hth
Al Camp

DaveL said:
Hi
I would like to create a Checkbox on a form which will indicate whether
another field (not shown on the form) contains any data. Could you help me
with the code please?
Many thanks
Click to expand...
Click to expand...
 
Back
Top