But the caption field used in set up in table design view do not ulpdate on forns already created but just for the current table ... seems the contrary of what been said

Good catch, and yeah, this is one of those "Access behaves differently depending on when things were created" situations.

The Caption property in the table does NOT retroactively update forms or reports that were already built. Once you drop a field onto a form, Access basically copies the caption into the label at that moment. After that, the form is independent. So if you change the caption later in the table, existing forms won't automatically update. You'd have to go back and change those labels manually.

Queries are a little different. In newer versions of Access, captions can flow through more dynamically in queries, especially when you add fields fresh. But even there, once you alias a field or build something on top of it, it can "break" that link.

So the rule of thumb is:
Set your field names and captions early if you can. After forms/reports are built, think of captions as mostly cosmetic at the table level, not something that will push changes downstream automatically.

Access doesn't really have a global "rename and update everywhere" system, which is why I always recommend locking down your naming conventions early on.

i understand yes,so never count on access tools to describe the purpose of your field and offer ourselves the gift of being clear from the start by creating self-explanatory field name !