Only way I know is Search And Replace... in the code this procedure works fine. In access2k and onwards fields refrences and query refrences are changed/renamed with the rename of the field.
Beth,
I use the Find & Replace Access add-in by Rick Fisher. Inexpensive ($37) and works great! I recently used this on a database with over 350 fields, this saved me a ton of time. His website is
Professional Development for Clients Large and Small
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.