Check Box Converted to Text in Report

[Donamese]

I have a form which uses check boxes for items which marks items as a check list. The check boxes link to the master table. I am trying to create a report where if the box is checked then the text on the report will say a given line other than the standard yes/no or true/false.

Form (with check boxes) Example:

Banana X
Orange
Apple X
Kiwi
Strawberry

The report will read:

Pick these up from the store

Apple
Banana


Currently the report will give me only a true/false or yes no. Is there a way to make the check box convert to specific text like this? If so how?

 

[GingerR]

What's your report's recordsource? Table structure, data types, sample data?

Is your data in rows in a table, with actual Yes/No check boxes in the same row? Then are you filtering on that check box in your report (where CheckBox = True)?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[PHV]

Have a look at the IIf function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Donamese]

There is a table with all the fields on the form. The Check boxes are seperated Banana, Apple, Kiwi, etc all have their own check box on the form and are each listed individually on the table. I have a simple query that is linked to the table, then the form is linked to that query.

The text boxes are made as true/false. Haven't set any filters on the report. I was trying to do an IIf statement of IIf([Table1]![Code1]=True,"Banana","") but no such luck. My guess is the syntax is off.

 

[GingerR]

Hi. You didn't quite answer my questions.

So you have a field named "Apple", a field named "Bannana", a field named "Kiwi", etc? If so, I suggest you re-think your table design since that's poor design and will cause you problems forever.

Again, please post your table structure, field types, sample data, and report recordsource. Thanks.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html