simple boolean syntax ?

[markjkubicki]

adding a new field to a table with code (which is not the problem... the field is created);


having trouble getting the syntax right to set the default value to "True" for boolean fields...


<...>
Set db = OpenDatabase(DbPath)
Set Td = db.CreateTableDef(TdName)
'Specify the fields.
With Td
Set Fd = .CreateField("AdditionalInfoRequired", dbBoolean)
Fd.DefaultValue = dbFalse 'have also tried dbNo, "No"...
.Fields.Append Fd
<...>
End With
'Save the table.
db.TableDefs.Append Td


(I would presume it's obvious; but when you're a self-taught, with no one across the aisle to ask the dumb ?s to...)
you guys become heros, andd for that... big thanx in advance)
Mark

[pbaldy]

Untested, but try 0.

[markjkubicki]

work perfectly (thanx)

[pbaldy]

Happy to help!