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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top