custom formatting for check box values in reports

C

coline

New Member
Joined
Apr 18, 2003
Messages
37
Hi, I would like to display data in a report that is based on check-box data entry, so the values in my table are 0 or -1. I have used the format property in the report to display these values as "Yes" or "No". However, ideally I would only like to display a "X" or "Yes" when checked and blank when unchecked. Is there any way to custom format how check boxes display in reports?

Thanks so much,
Coline
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
Not directly, but you could use a textbox instead, with an expression like:
=Iif([myChkBox]=TRUE,"Yes","") -- adjust checkbox name to suit

Denis
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Having a problem in the expression builder, very new to Access. It thinks I'm trying to use Automation objects?
2
Replies
15
Views
950
Micron
M
C
  • Question Question
Linked Excel table in Access - field values change as I navigate?
Replies
5
Views
590
welshgasman
welshgasman
K
  • Solved
Change Excel cell color based on Yes \ No Access form Field result
Replies
3
Views
764
Micron
M
JenniferMurphy
  • Question Question
How to structure a variable product rating database
Replies
5
Views
935
mdmilner
M
T
  • Question Question
Display a list of the count of each unique value in an Access report.
Replies
1
Views
641
Micron
M

Forum statistics

Threads
1,224,586
Messages
6,179,730
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top