When are field captions inherited from the source tables?

[kattatonic1]

I have carefully put captions on all fields in my tables because I use conventional prefixes for fieldnames. E.g., fieldname: strLastName / caption: Last Name. I can't figure out why some queries and some forms inherit them beautifully and why some revert to the fieldnames.

Hoping it's a simple roll-yer-eyes question for one of you on this fine day!

Kay from Toronto
Access 2010

[JeroenMioch]

My captions never inherit them, strangely.
I never name them either because they dont do anything for programming use.

And in the rare case that they do, i use a prefix like you, "cptLastName" for example.
I would stay clear from the prefix "str" by the way, as that is sometimes used to point to a string, like "strDate" in VBA.

[kattatonic1]

I'm not sure I understand what you're saying about your experience, JeroenMioch. Unless your users always see the awkward fieldnames with their prefixes on Forms? Do you mean that you retype every fieldname on every form? I have dozens of forms. That would be a lot of work and maintenance.

[June7]

I never set these properties in tables just because they do cause confusion. The worst is to set Lookup in table.

Expressions must reference the actual field name.

As for forms/reports and controls, depends how you create them. Wizards should use the caption for associated label. Drag a field from the field list and it should use the caption for associated label.

I don't use prefixes on field names.

Retyping? That's what copy/paste is for.