By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

change field names

P: 78
Is there a way to change field names throughout my db? I erroneously named a date field as "Date" and should have been named something else cause this may cause me problems as I start using this field in calculations. Progressive Enlightenment has taught me that this was something I should not have done.
Mar 1 '07 #1
Share this Question
Share on Google+
3 Replies


markmcgookin
Expert 100+
P: 648
Is there a way to change field names throughout my db? I erroneously named a date field as "Date" and should have been named something else cause this may cause me problems as I start using this field in calculations. Progressive Enlightenment has taught me that this was something I should not have done.
Well you could just go back to properties > Field Name. But chances are that any reference to this will need to be changed if you are referencing it in code in the forms.
Mar 1 '07 #2

P: 78
Yeah, I kinda wanted to do it automatically without having to do it manually in all forms, reports and queries, and not using the auto correct in Access.
Mar 1 '07 #3

Rabbit
Expert Mod 10K+
P: 12,366
The only alternative to this is vba code which could take more time unless someone already has code that has been tested.
Mar 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.