change query results

[InvGrp]

In my form and report I use a field called "use" and it displays the contents as either "R", "Condo" and "Apt" (this comes from the actual data).

I'd like to have the data displayed differently in the form and in the report.

Can I display it like:

if results is "R" displays as "SFD"
if results is "Apt" displays as "Units"
if results is "Condo"...this one is OK.

Thanks.

Using Access 2000.

 

[maxmangion]

if you do not want to change the actual data, create an unbound text and then use a case statement to update the value of the unbound text box eg.

Select Case Me.FieldName
Case "R"
Me.UnboundBoxName = "SFD"
Case etc
End Select

 

[neileg]

Or cfeate a table that has two fields and three records. Populate this with the actual data and the desired format and join this to your existing data.