yes/no again

  • Thread starter Thread starter MSD
  • Start date Start date
M

MSD

Sorry I didn't explain my problem more clearly.

I had said "I'm trying to display a yes/no field in a multi-select list box
as a checkbox" -

I meant that I want it to appear as either yes or no rather than '0' or
'-1'.

Thanks again so much for trying to help,

Emma
 
I assume your are using a textbox then to display the field. Try setting the
Format property of the textbox. It should have options for Yes/No,
True/False, or On/Off.
 
Use the format function in the underlying query.

SELECT SomeField, Format(YourYesNoField,"Yes/No") as YNField
FROM YourTable
 
Back
Top