Change a Textbox's Value

  • Thread starter Thread starter David Whitaker
  • Start date Start date
D

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"
 
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"
Click to expand...

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")
 
Back
Top