CheckBox format

[rccline]

I want to view the checkbox in my yes/no field.
I select the various formats on the table design for the data type yes/no. There are three formats:
1. yes/no
2. true/false
3. on/off

Regardless of which format type I select, I don't see the check box in my tables or queries.

Access Help doesn't provide the answer. Access help sends me to properties tab in the toolbar for the table. There, for default view, I only see datasheet, PivotTable or PivotChart.

Can someone please advise.

thanks.

Robert

 

[PHV]

Choose On/Off

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

You should be viewing/editing value only in forms and reports. Use a check box control and bind it to your field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[rccline]

Thanks guys. I found the answer in a beginner's Access instructional manual.

I discovered that if you go to the Lookup properties under data type, that is where you set the display to show text or check box.

Cheers,

Robert