Hi.
I regularly import tables with many fields from a third party application into Access 2000.
These fields all have captions as well as field names (obviously!) but I give them much more meaningful "friendly" names. But to do this I must first manually delete all the captions.
Is there an easier way?
Thanks in advance.

Not with a macro. You can write code that loops through the fields collection of the tabledefs and update any field that has a caption. Look for help on collections to see code samples. Or look here.