Yes/No shows up at 0 and -1 (1 Viewer)

[rjkimme]

I have a yes/no valued field in my table. When I use a form that queries the database and posts the information requested, the status text box does not return yes or no but 0 or -1. what am I doing wrong.

 

[Pat Hartman]

Open the properties dialog for the status text box and change the format to yes/no.

 

[aqif]

I believe changing format alone will not help....if u want yes/no values to be displayed than goto the lookup tab and change the display control to text box.

Cheers!
Aqif