returns value 0 and 1 convert to yes or no 1

[47redlands]

I have a textbox on a form with an expression:

The expression is =DLookUp("[RestrictedView]","Seats","[SeatNumber]=[cboAvailableSeats]")

it returns the value 0 and 1 because feild RestrictedView in table Seats is Data Type Yes/No

How do I get it display Yes and No in the textbox of the form in Form View?

Thank you

 

[MajP]

you can set the format property of the field to yes/no true/false off/on

 

[47redlands]

Thanks,

MajP where do I set the property on the textfeild?

Thank you in advance

 

[MajP]

I said that wrong. I meant to say you can set the format property of the Text Box. In the properties of the form under the "format" the property is "format".

However, you can also set the display property on the field under "format" in the table properties.