This is especially burdensome because when you drop a bound control onto a form, Access gives them the same name
This is a fact of Access life. Worse, if you use a wizard to create a report or form, you get that for every control. So I deal with it by using the wizard to get a form in short order, but I go through every control and rename them right away. At the same time, Name Autocorrect is turned off. This will avoid any ambiguity on the Access side where it may not be able to distinguish between a field vs a control, plus you will never have to wonder what type of control you're dealing with when you look at code. Suggest you adopt a naming convention:
http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837
What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.