OK to change field name in table?

[Geoff Cox]

Hello,

Can I change the name of a field without causing havoc to the table's
structure?!

I have for example address-1 which is not a correct form, should be
for example address_1 - correct?

Cheers

Geoff

 

[Dirk Goldgar]

Hello,

Can I change the name of a field without causing havoc to the table's
structure?!

I have for example address-1 which is not a correct form, should be
for example address_1 - correct?

Sure, you can change it without harming the table in any way. If you have
forms that are based on this table, or queries that include the table, you
may have to change the field name there, too. I say you *may* have to,
because it's possible that the Name AutoCorrect feature, if enabled will do
it for you. I don't use that feature, because it has a tendency to make
mistakes and cause more errors than it solves, but some people do use it.

 

[Geoff Cox]

Sure, you can change it without harming the table in any way. If you have
forms that are based on this table, or queries that include the table, you
may have to change the field name there, too. I say you *may* have to,
because it's possible that the Name AutoCorrect feature, if enabled will do
it for you. I don't use that feature, because it has a tendency to make
mistakes and cause more errors than it solves, but some people do use it.

Thanks Dirk - pleased to hear that renaming is OK.

Cheers

Geoff

 

[Tony Toews [MVP]]

Can I change the name of a field without causing havoc to the table's
structure?!

I have for example address-1 which is not a correct form, should be
for example address_1 - correct?

Also consider using a tool to locate and change all the occurrences of
the field within your FE. Especially in code where AutoCorrect won't
work.

See the Scan and replace utilities section at the Microsoft Access
third party utilities, products, tools, modules, etc. page at my
website.
http://www.granite.ab.ca/access/thirdparty.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Geoff Cox]

Also consider using a tool to locate and change all the occurrences of
the field within your FE. Especially in code where AutoCorrect won't
work.

See the Scan and replace utilities section at the Microsoft Access
third party utilities, products, tools, modules, etc. page at my
website.
http://www.granite.ab.ca/access/thirdparty.htm

Tony

thanks for the info Tony.

Cheers

Geoff