Programmatically Setting Default Values (97 SR-2 on Win NT 4.0)

Topic

New Reply

I have built a module that will copy a “bare-bones” empty table, then add fields to it based on fields created in a crosstab query. In that, I then have a table that has several fields created on the fly. Is it possible to set the default value to the new fields I’ve added? I did not find it in “Attributes”, and I’m not sure where else to look.

Thanx

Jeff

Reply | Quote

Replies

Hi Jeff,
Fields have a DefaultValue property which you can set – it’s just Field.DefaultValue rather than being one of the Field.Attributes.
Hope that helps.

Reply | Quote

Set fld = TDFTest.CreateField(qdfField.Fields(2).NAME, dbText, 11)
fld.DefaultValue = 0
TDFTest.Fields.Append fld

HEY MOE! IT WOIKS! Nyuk Nyuk Nyuk.

Thanks much.

Reply | Quote