VBA table properties

B

BennyDHill

Hi,

I am creating a table using a query that has checkboxs in three columns. I
have set the settings in the queries properties to allow this. Howver once
the table is made it does not have checkboxes, but numbers. I cannot work
this out, and since the query needs to be re-run i can't change the settings
again everytime the table is made (in the table properties design view).

What to do?
 
K

Ken Snell \(MVP\)

To see checkboxes as the "field", the table's checkbox field must have its
Lookup property set to Checkbox. The numbers that you see (-1 and 0)
represent True and False respectively.
 
B

BennyDHill

Hi,

I was aware of that and have tried already.

Ken Snell (MVP) said:
To see checkboxes as the "field", the table's checkbox field must have its
Lookup property set to Checkbox. The numbers that you see (-1 and 0)
represent True and False respectively.
Click to expand...
 
J

John W. Vinson

I am creating a table using a query that has checkboxs in three columns. I
have set the settings in the queries properties to allow this. Howver once
the table is made it does not have checkboxes, but numbers. I cannot work
this out, and since the query needs to be re-run i can't change the settings
again everytime the table is made (in the table properties design view).
Click to expand...

You shouldn't be looking at either the table or the query datasheet. Tables
contain DATA - a checkbox isn't data, it's a tool for interacting with data!

Create a continuous Form bound to the query, or to the table; put checkboxes
on the form; and use *that* to view and interact with the data. The table
datasheet should be used only for debugging - and having -1 for True and 0 for
False is probably beneficial, because that shows you what is actually IN the
table.

John W. Vinson [MVP]
 
Top