Interpret check boxes on report

  • Thread starter Thread starter cs
  • Start date Start date
C

cs

I have a couple of checkboxes in my table but on a report
I don't want to display the check boxes, I want to for ex:
If Transferable is checked, I want the report to say
Transferable? Yes or if not checked Transferable? No. I
appreciate any pointers, I haven't worked with reports
much.
 
I have a couple of checkboxes in my table but on a report
I don't want to display the check boxes, I want to for ex:
If Transferable is checked, I want the report to say
Transferable? Yes or if not checked Transferable? No. I
appreciate any pointers, I haven't worked with reports
much.
Click to expand...

Add an unbound text control to the report.
Set it's control source to
=[CheckBoxField]
Set it's Format property to:
;"Transferable?Yes";"Transferable?No"

Look up
Format Property + Numbers and Currency Datatype
in Access Help.
 
Back
Top