Update Caption for Fields using code?

[Karl]

Can you update the caption property for fields in a database using code?

[Tom van Stiphout]

On Mon, 13 Nov 2006 19:23:15 GMT, "Karl" <so*****@sbcglobal.biz>
wrote:

You can update any property, so I'm thinking this one as well. Just
note that if a property value is not yet set, the entire property may
not exist, so code like:
currentdb.tabledefs(x).fields(y).properties("Capti on")="test"
may fail with an Object not Found - like error.
Use CreateProperty in those cases.

-Tom.

>Can you update the caption property for fields in a database using code?