yes/no again

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
 
W

Wayne Morgan

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.
 
J

John Spencer (MVP)

Use the format function in the underlying query.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

yes/no field and forms 1
yes/no field format 1
adding yes/no field 2
Displaying Yes or No rather than 0 or 1 1
Yes/No Query 1
Using a Yes/No field to trigger a calculation in another field - J 6
Yes or No 2
CrossTab Query How Do I change Column Headings... 2

Top