How to format Yes/No field

[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

 

[Ken Snell]

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.

 

[Robin Chapple]

Thanks very much. Exactly right.


"Peace, Health and Happiness in 2004"