Hello Friends
I am creating a table using create table query(using the back end - Ms access). My table contains boolean fields.
i am executing following code.

option explicit
dim y as boolean
dim n as boolean

Form_load
y=True
n=False

'creating a table using connection con
con.execute "create table try(a yesno, b yesno)"

but when i am adding data to the table if value is true it stores -1
and if false it stores 0.
want to store true and false instead.
but now for that i have to set format property of the fields in Access. Do not want to do this explicitly. want it to be set while creating the table.
Can anybody help me for this? want to know the syntax to set the format property of the field.
it's urgent.
thanks in advance!