Diplaying Option Button Choices on a Report

[AJ]

I am fairly new to Access and currently use a combination of Access and
InfoPath for many of my projects. I have designed an infopath form that
submitts data changes to my access data base. Many of the changes are in the
form of option buttons. Currently the reports I provide to my director show
the demographics along with the status change; however, the status change is
shown as a numerical value, instead of text. (i.e. under review, completed,
awaiting approval). I currently have text box on the report that shows the
key (i.e. 1 = apporved, 2 = under review, etc), unfortunatley, we are about
to start disseminating these reports to the executive management team and my
director feels it would be more appropriate if we have the report display the
actual text. Any suggestions or ideas would be greatly appreciated.

 

[Marshall Barton]

I am fairly new to Access and currently use a combination of Access and
InfoPath for many of my projects. I have designed an infopath form that
submitts data changes to my access data base. Many of the changes are in the
form of option buttons. Currently the reports I provide to my director show
the demographics along with the status change; however, the status change is
shown as a numerical value, instead of text. (i.e. under review, completed,
awaiting approval). I currently have text box on the report that shows the
key (i.e. 1 = apporved, 2 = under review, etc), unfortunatley, we are about
to start disseminating these reports to the executive management team and my
director feels it would be more appropriate if we have the report display the
actual text. Any suggestions or ideas would be greatly appreciated.

Create a little lookup table with the text description along
with the number as the primary key. Then Join this table to
the report's current record source table/query so you can
include the description in the report's field list.

Most applications have many of these little tables. Not
only do they take care of your question, but they also allow
a description to be changed without having to modify
anything else in the application.