Values from Option buttons

[Heeeeelp]

Hi Everyone,

I have a form with an option group that has been assisgned the following values: 1-Active 2-Prospect.

Can someone please let me know what I need to do to have the report display the words "Active" or "Prospect" instead of the numberical values that access stores in the tables after the user makes a selection?

Thank you in advance for your help.

Regards,
Tess

 

[dhookom]

I would probably create a small table like:
[tt]
tblStatus
============
Code Title
1 Active
2 Prospect
[/tt]
Then join this table into your report's record source and join the Code field with your un-named field. Display the Title field in your report.

A quicker, less flexible method is to change the name of your text box and set its control source to:
[tt]
=Choose([Un-named Field],"Active","Prospect")
[/tt]

Duane
Hook'D on Access
MS Access MVP