what is the type i should give for CheckBox to display in datasheet vi

[nandamurisrihari]

Hi,

what is the type i should set for checkbox to get generated in datasheetview displayed in my subform???

regards,
Please help me out
srihari

 

[KenReay]

Hi

You need it to be type Boolean ie Yes/No in the drop down list of column types in table design Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[nandamurisrihari]

Hi,
I was aware of that in table design.But i want to create one temporary table directly in MSAccess code with one column containing checkbox.
Iam able to create one colum with type as dbinteger and one as dbtext ,so that i can enter only those type.
but for checkbox what should i set in the code(see the below example with checkbox followed by type)

Set tdf = daocon.CreateTableDef("temporaray_table&quot
With tdf
.Fields.Append .CreateField("Checkbox", ????)
.Fields.Append .CreateField("Name", dbText)
.Fields.Append .CreateField("Number", dbInteger)
End With
daocon.TableDefs.Append tdf

Regards
srihari

 

[KenReay]

Hi

You need type dbBoolean, as per list below

For a Field, Parameter, or Property object, the possible settings and return values are described in the following table.

Constant Description
dbBigInt Big Integer
dbBinary Binary
dbBoolean Boolean
dbByte Byte
dbChar Char
dbCurrency Currency
dbDate Date/Time
dbDecimal Decimal
dbDouble Double
dbFloat Float
dbGUID GUID
dbInteger Integer
dbLong Long
dbLongBinary Long Binary (OLE Object)
dbMemo Memo
dbNumeric Numeric
dbSingle Single
dbText Text
dbTime Time
dbTimeStamp Time Stamp
dbVarBinary VarBinary Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[nandamurisrihari]

Hi,

i couldnt get checkbox by anyof the above dbboolean..
can u specify out that dbbollean which will generate checkbox...

regards
srihari