Setting values in a text box

[bozdog]

I have a report based on a query that contains a text box
(textboxA)which displays a numeric value (1 - 3). What I would like to do is
place another text box (textboxB) on the report that gives a text string
dependant on the value of the numeric valuein textboxA.
e.g
If textboxA =1 then text box B= "Good"
If textboxA =2 then text box B= "Average"
If textboxA =3 then text box B= "Poor"

Any help appreciated.

Thanks in advance

 

[Duane Hookom]

Set the control source of the second text box to:
=Choose([textboxA],"Good","Average","Poor")

 

[bozdog]

Worked a treat, thanks again.

Set the control source of the second text box to:
=Choose([textboxA],"Good","Average","Poor")

--
Duane Hookom
MS Access MVP
--

I have a report based on a query that contains a text box
(textboxA)which displays a numeric value (1 - 3). What I would like to do
is place another text box (textboxB) on the report that gives a text
string dependant on the value of the numeric valuein textboxA.
e.g
If textboxA =1 then text box B= "Good"
If textboxA =2 then text box B= "Average"
If textboxA =3 then text box B= "Poor"

Any help appreciated.

Thanks in advance