CREATE TABLE and Boolean Columns presentation

[Emil]

Hi everyone!

I am using CREATE TABLE query to create a table.
My problem is that I want the boolean column to appear
with a tick box when the table is opened not 0/-1 value

I am using the following statement:
CREATE TABLE Foo(ID AUTOINCREMENT, BoolCol BIT)

My question:
What statement shall I use for boolean columns to force
access to display tick box?

Thanks in advance!
E

 

[Tim Ferguson]

My problem is that I want the boolean column to appear
with a tick box when the table is opened not 0/-1 value

Just drop a check box control onto the form and bind it to the appropriate
question. You are using a form aren't you?

HTH


Tim F

 

[TC]

Just drop a check box control onto the form and bind it to the appropriate
question. You are using a form aren't you?

If he is using a datasheet, there is a cusom property. I think it is
DisplayControl. And I >think< the value for a checkbox, is 109 - but that is
from memory

TC

 

[Guest]

You can also try this . . . . it worked for me

In the design view change the column type from yes/no to
text then save changes. Then open the table. The column
should be in yes or no format. Now go back into the
design view and change the type back to yes/no. It now
should be a check box.