Change a Textbox's Value

[David Whitaker]

I have got a textbox in the detail area of a report that has the value of
1,2, or 3. Is there a way to make another empty textbox equal text, based
on the box's value like
"1" would equal the word "low"
"2" would equal the word "medium"
"3" would equal the word "high"

 

[fredg]

I have got a textbox in the detail area of a report that has the value of
1,2, or 3. Is there a way to make another empty textbox equal text, based
on the box's value like
"1" would equal the word "low"
"2" would equal the word "medium"
"3" would equal the word "high"

Add an unbound text congtrol to the report.
Set it's controlsource to:
=IIf([ControlA]=1,"low",IIf([ControlA]=2,"medium","high"))

You could also use the Choose() functions instead of IIf().
=Choose([ControlA],"low","medium","high")