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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check List Report 4
Excel Move or Copy Stopped Working? 0
Sum Check Box 5
Report: how to remove (not hide only) checkbox 1
Filtering subreports on main report 0
Report Output 13
check box data in report.. 5
Coding from Check Box 10

Back
Top