Old Access Table and Checkboxes

[Erika]

I have an old Access Table that I would like to use however one of the fields
displaying a 0 or -1 and I would like to make it a checkbox field.

Is there a way for Access to interrupt the 0 or -1 into a checkbox field?

 

[Tom Wickerath]

Hi Erika,

Take a look at the Products table in the sample Northwind database
(Northwind.mdb). The Discontinued field displays a checkbox. In table design
view, select the Yes/No field. Click on the Lookup tab in the lower window.
Set the Display Control to Check Box.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Allen Browne]

Open the table in design view.
Select the field.

In the lower pane, click the Lookup table.
Set the Display Control to: Check box.