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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LawDiva - 10 Jan 2006 02:17 GMT

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

Reply to this Message

Allen Browne - 10 Jan 2006 02:37 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> In Access 2003 I've created an form Option Box w/3 values (displaying as
> 1,
[quoted text clipped - 3 lines]
> Option checkbox 2 Value=2 Report should display text=Repair
> Option checkbox 3 Value=3 Report should display text=Closed

Reply to this Message