How do I make option box values (1,2,3) display as text in report

L

LawDiva

In Access 2003 I've created an form Option Box w/3 values (displaying as 1,
2, 3). In a report how do I display the values as text?

Option checkbox 1 Value=1 Report should display text=Active
Option checkbox 2 Value=2 Report should display text=Repair
Option checkbox 3 Value=3 Report should display text=Closed
 
A

Allen Browne

Create a table with fields that teach Access what these numbers mean.

For an example, open the Northwind sample database.
The Orders form has an option group for Shippers.
The Shippers table has the matching values.
The Invoice report shows the shipper name instead of the number.
 
Top