Field Properties

[mans]

Hello,

I am using VB6 with Access2000. I am also using the code below to append a field called "end" to a table called "Table", the code works fine (ignore declarations). Can somebody please let me know what code I can add so I am able to define the field properties which must include whether: a value for the (new) field is required (defaults to No in Access), a zero length is allowed (defaults to No in Access) and if duplicates are allowed (defaults to Yes in Access).

Set td = daoDB36.TableDefs("Table&quot
Set F = td.CreateField("end", dbText)
td.Fields.Append F

Thank You

 

[Mostafavi]

Use this code:

Set td = daoDB36.TableDefs("Table&quot
Set f = td.CreateField("end", dbText)

f.Properties("Required&quot = True
f.Properties("AllowZeroLength&quot = True

td.Fields.Append f

[sig][/sig]