Unbound control display (2002)

[santosm]

Hello All,
I have a form (continuous forms display) with an unbound control. I want to change what the unbound control displays depending on what is in another field. How can I make the control display different text? For instance, I have a field called field_disposition. This field has data stored as a number like 0,1,2,3. Depending on that number I want the unbound control to display some text like "installed", "returned","Retained",etc.

So far everything I have tried only changes all of the controls to the same text no matter what the disposition field has for a value.

Thanks,
Mark

[MartinBall]

Set ControlSource for unbound control to something like:
=Switch([field_disposition]=0, "installed", [field_disposition]=1, "returned", [field_disposition] =2, "retained")

Regards
Martin

[charlotte]

This is the nature of unbound controls on a continuous form. There is only one set of controls, no matter how many records you see, and an unbound control can only get it's information from the current record. You would be better off using a query behind your form and including a calculated field that reflects the value based on another field. Then you can bind a textbox to that calculated field on the form and it will accurately reflect the value you want to see of each record. The Switch() function can be used in a query as well as in a controlsource, but you might find Choose simpler. Your calculated field would look something like this:

Choose([field_Disposition] + 1, "Installed", "Returned", "Retained", ...)

Choose uses indexes starting at one, so if your lowest value is zero, you have add one to it. Choose returns the indexed item from the list.