How to format Yes/No field

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a table with three yes/no fields.

Data Type: Yes/No
Format: Yes/No

Two display yes or no as text.
The third shows the tick box.

How do I change the tick box to text?

Thanks,

Robin Chapple
 
In the design view of the table, select the field that shows as a checkbox.
Then, at bottom of screen, click on Lookup tab. Change Checkbox to Text Box
in the dropdown list on that tab.
 
Thanks very much. Exactly right.


"Peace, Health and Happiness in 2004"
 
You must log in or register to reply here.

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

Exporting Yes/No field to XLS 9
Check Boxes Yes/No 1
table defaults to -1 or 0. Please, how to return to yes or no. 1
Yes/No field custom format text color 1
Access how do you set a yes/no data type as required? 0
Access Microsoft Access Calculated Field - Expiry Date 0
Yes/No field check box 4
MS Access problem 0

Back
Top