How translate yes/no column to text on form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that reads a column of yes/no format. I need to display "Bid"
if the value is Yes, blank if No. I have tried all kinds of IIF statements to
get this but nothing works. All I can get is 0 for No and -1 for Yes.
Any ideas?
 
Did you try this in the control source of the text box in the form
=IIf([FieldName] = True, "Bid" , "")
 
I have a form that reads a column of yes/no format. I need to display "Bid"
if the value is Yes, blank if No. I have tried all kinds of IIF statements to
get this but nothing works. All I can get is 0 for No and -1 for Yes.
Any ideas?
Click to expand...

You don't need an IIf statement.
Use a regular UNBOUND TEXT control.
Set it's control source to the Yes/No field.
Set it's Format property to:
;"Bid";""

If the value is Yes (-1), "Bid" will display, otherwise the control
will be blank.

See Access help.
Format property + Number and Currency datatypes
 
Back
Top