Update Caption for Fields using code?

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

re: Update Caption for Fields using code?

On Mon, 13 Nov 2006 19:23:15 GMT, "Karl" <someone@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.