A Good Source for Naming Conventions

[DigitalAdrenaline]

Hi Guys, I'm just naming all my form elements in the Property Sheet and I'm appearing to double-up my names within text, label, combo boxes etc.

All seems ok. I WAS confusing myself IN giving Text Boxes and Label Names the same tag, so I just deleted all label names from my text Boxes.

[alansidman]

https://en.wikipedia.org/wiki/Leszyn...ing_convention

[CJ_London]

Not sure what your question is or the point you are trying to make but my convention is to precede all control names with a 2 or 3 letter abbreviation for the control type e.g. txt.., cbo..., opt... etc although I tend to not bother with labels unless I am referencing them in code - in which case I use lbl…. I also do this before I start writing code - otherwise the renamed control will not find the associated code unless you manually relink it.

I also don't use spaces or underscores in my naming conventions - including field and table names but do make use of the caption property for what I would call 'output queries' - i.e. queries that are final output as forms, reports or exported to excel etc to provide a more 'friendly' heading e.g. the caption for a field called custName might be Customer Name. OK you can change the caption in the associated label but if the same table/query is used in different forms/reports that is multiple places to change it - and the direct export or viewing of a query would still show the field name. Note I tend not to set the caption until the development is finished or close to - otherwise during development seeing the column heading as 'customer name' in query/form/report view but the field name in the query grid as custName can be a bit disorienting.

[DigitalAdrenaline]

Hi Ajax, sorry for that confusing post. I did come back to delete it after solving my naming issue but couldn't see any delete option, so I instead just erased the body of my post. I had confused myself in prefixing my Text/Combo Box Name and Label Name fields with both lbl.. causing me to double-up my user naming. So, I simply deleted all text from the Label Name field for my Text boxes to be empty, and just populated the Name field with txt... and cb... etc. Hope that makes sense. Screenshot below. BTW, your explanation above is excellent. Well communicated.

[orange]

Here is a link to some Naming ideas for consideration.

[DigitalAdrenaline]

Thanks Orange, that's a good cheat-sheet. Cheers.