simple boolean syntax ?
Windows XP 
Access 2007
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
Reply With Quote
