displaying a single text character for a number value on a subform

  • Thread starter Thread starter Ken Gehle
  • Start date Start date
K

Ken Gehle

I have a form called "clients" that has a combo box field for an e-mail
subscription. The choices are unsubscribed (underlying value=0), subscribed
(underlying value=1) & not subscribed (underlying value=2). This info also
shows on a subform on a form called "companies". I would like for the data
onthis "companies" subform to show U for value 0, S for value 1 and N for
value 2. I am stupped in how to do this.

Thanks for any hints/help

Ken Gehle
 
Ken Gehle said:
I have a form called "clients" that has a combo box field for an e-mail
subscription. The choices are unsubscribed (underlying value=0),
subscribed
(underlying value=1) & not subscribed (underlying value=2). This info also
shows on a subform on a form called "companies". I would like for the data
onthis "companies" subform to show U for value 0, S for value 1 and N for
value 2. I am stupped in how to do this.
Click to expand...



You could easily have a text box with its controlsource set to the
expression:

=Choose([Subscribed]+1, "U", "S", "N")

where "Subscribed" is the name of field that contains the numeric
subscription value.
 
Back
Top