CREATE TABLE and Boolean Columns presentation

  • Thread starter Thread starter Emil
  • Start date Start date
E

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
 
My problem is that I want the boolean column to appear
with a tick box when the table is opened not 0/-1 value
Click to expand...

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
 
Tim Ferguson said:
Just drop a check box control onto the form and bind it to the appropriate
question. You are using a form aren't you?
Click to expand...


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
 
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.
 
Back
Top