Display text instead of value # from check box in report

[SnoWBunnY]

Hello!

I was just wondering how to display text in my report instead of the value number from my check boxes.
I have and option group with 3 choices to pick from. chkEmployee = 1, chkPatient = 2 and chkVisitorVolunteer = 3
How do I get text in my report instead of 1,2,3 and where do I modify it ... from my Query or can I just do it from my report?

 

[mikey69]

Probably the easiest is to use the dlookup function either in the underlying query or in the on format event in the report. Search the help file for syntax and examples.

If you have a table with the text values in, you could relate irt to the main table and include the text field in the query.

hope this helps