Report Yes/No instead of True/False for bool dataType field in Access

[lsyhu]

Hi,

I have a yes/no data type in my Access database. When I use ASP to query it ("Select myFields from myTable&quot and display the resultSet, it's always "True"/"False". But I want it to be "Yes"/"No". I have already choosen the format for this field to be "Yes/No" in Access, but it did not work. Is there any way to get Yes/No instead of True/False?

Your quick response is greatly appreciated.

Lisa

 

[spencertaylor]

Use an If statement when displaying the results in the browser:

If recordsetname.yesnoField=True then
response.write "Yes"
Else
response.write "No"
End If