access97 form display problem

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I have created a form. One text box is from a table that
stores the following vlaues: 1,2 or 3. On the form I want
to show this field as "NEW" if value is 1, "CHANGE" if
value is 2 and "TERM" if value is 3. I understand how to
use control source is I only am looking for 1 or 2
responses but what about this case?
 
Susan said:
I have created a form. One text box is from a table that
stores the following vlaues: 1,2 or 3. On the form I want
to show this field as "NEW" if value is 1, "CHANGE" if
value is 2 and "TERM" if value is 3. I understand how to
use control source is I only am looking for 1 or 2
responses but what about this case?
Click to expand...

=Choose([YourField],"NEW","CHANGE","TERM")
 
Back
Top