[RESOLVED] Modify Caption Property of Table

[swoozie]

How do you set the CAPTION property of the access table/columns you have created in code/dynamically?

I am not finding any real references on the topic.
I create,then alter the table using:

"ALTER TABLE " & NewTbl & " ADD COLUMN " & FldName & " " & fldType

and I want to modify the caption setting at the same time.

[Ecniv]

Uhhh Going back to DAO I think (might be wrong) that the caption is a property of the column. I assume that is what you want?

Once the table has been created, open a tabledef of that table and check its properties.

MSDN help

I think that if you can get to it you should be able to change it.

If you are in ADO you need to get through ADOX, a schema, and check the caption property.