How do I convert a number to a text value on a report

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

Guest

I have a radio group on a form of mine. In my table I store it as a number
rather then all the text, but on my reports I print for users I would like to
display the full text. How can this be done?

Thanks ahead of time.
 
Aludaan said:
I have a radio group on a form of mine. In my table I store it as a number
rather then all the text, but on my reports I print for users I would like to
display the full text. How can this be done?
Click to expand...


Create a table with two fields, one for the number and the
other with the text. Then your report can be based on a
query that joins the two tables to make the text available.
 
There is no other way? There are only 2 possible texts that it could be and I
didn't really want to create a whole database for 2 texts.
 
There is no other way? There are only 2 possible texts that it could be and I
didn't really want to create a whole database for 2 texts.
Click to expand...

Marshal's suggestion was to create a table, not a new database!

However, for 2 choices just add an unbound control to the report.
Set it's control source to:

=IIf([FieldName]=1,"This is my text","This is my other text")

Make sure the name of this control is not "FieldName".
 
Heh, my bad. I meant to say table, not database. I was in a hurry when I
typed it so I never proof read it before I sent it.

But your suggestion will work great too!

Thank you very much guys.

Aludaan

fredg said:
There is no other way? There are only 2 possible texts that it could be and I
didn't really want to create a whole database for 2 texts.
Click to expand...

Marshal's suggestion was to create a table, not a new database!

However, for 2 choices just add an unbound control to the report.
Set it's control source to:

=IIf([FieldName]=1,"This is my text","This is my other text")

Make sure the name of this control is not "FieldName".
Click to expand...
 
Back
Top