I’ve looked but haven’t found any option or guidance on how to prevent the generation of field captions when creating an Access database.
Use of captions in Access is a nightmare - no matter what alias you choose to give a field in a query, Access persists in using the field’s ‘caption’ value, if one exists. This then allows two or more query columns to have the same name - which for the unwary (like my clients) can be a confusing show-stopper.
(Yes - I can create code that removes them once I’ve built the database…but happy not to explore that option. And yes, I could modify the DDL (VBA) before I run it to prevent the caption from being created. But, I’d rather a toggle option in TOAD.)
Thanks for any advice