List to check boxes

[tanyapeila]

I'm not sure if this can be done, but then again anything is possible right?



I have a field "options" and the choices are "option 1", "option 2", "option 3", "option 4"

I would like this to look like this on my report and only have the one the user selected checked. The others will remained unchecked. There will never be an instance where two boxes will be checked in one records

[orange]

Instead of checkboxes, I'd suggest you review an Option Group. Only allows 1 choice from the group by design.
The check boxes will allow you to select 0,1 or more.
However, since it's only for reporting, the checkbox would work fine.

How is the data selected/entered originally?

[tanyapeila]

I'm looking into the Option Group however the form we enter this information in we only use the Datasheet View. I don't think the Options group will work with that view.

[orange]

OK. When I first read the post I thought (assumed) it was for data entry, but since it's just for output, Go for it!