Setting values in a text box

  • Thread starter Thread starter bozdog
  • Start date Start date
B

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
 
Set the control source of the second text box to:
=Choose([textboxA],"Good","Average","Poor")
 
Worked a treat, thanks again.

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

--
Duane Hookom
MS Access MVP
--

bozdog said:
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
Click to expand...
Click to expand...
 
Back
Top