Because I learned Access on my own while building a database, I now find that I have a few inappropriate field names (for example “E-mail” instead of “EMail” which forces me to use brackets in code because of the hyphen). By now, of course, that field name is embedded in numerous queries, forms, reports, and code modules.
My question is, is there any easy way to locate all the incidences of such a field and change them? I don’t mind changing them manually once I find them if necessary – it’s finding them that is the issue so I don’t miss one (or twelve ) and have something malfunction when someone else is using the database.
thanks,
-cynthia