changing defaultvalue

[dirk van waes]

Hi,
On a form, I want (depending on what the user wants) to be able to change
the defaultvalue of a field in a table. (not the source-table of that form).
Is that possible? How do I do that?
TIA
Dirk

 

[TC]

That's an unusual requirement. I assume you have good reason for it?
Try the following:

(untested)

dbengine(0)(0).tabledefs![YourTableNameHere].fields![YourFieldNameHere].defaultvalue
= 99

Replace 99 with the desired new default value.

HTH,
TC

 

[TC]

PS. If you have not yet /set/ a default value for that field, that code
will probably fail with a "property not found" error. You could enhance
the code to create the DefaultValue property if it did not yet exist,
or, you could just ensure that you set a default value manually, once,
so Access will create that property for you.

HTH,
TC

 

[dirk van waes]

Thxs Tc, I'll give it a try