Changing a Field name to reflect all forms without affecting relationships in DB?

[fuecheefang]

Is it possible to change a field name (same data type) just rename the field in tables and forms without affecting the DB? Help.



Thanks in advance.

[ranman256]

as long as the field itself is not in the relationship.
(the bad part of renaming fields....dont)

[NTC]

If you left the default Auto Name feature in place I think you can. Make a copy and try.

That feature had a strong reputation for being one of the major causes of corruption back in the 2003 era vintage and was recommended always to be turned off. I don't know if it is still the case today with more current releases.

In any case - a table's field name is like the foundation of the house and so is very tricky to attempt to change after the house is built. You must also deal with queries if the Auto Name change feature is disabled or does not work.

[fuecheefang]

Thanks for the tips! I backed up the DB and playing around with changing the field names. the field name I need to change was a request from the user. fortunately it has no relation to other tables, but does populate in Forms and Reports. So far its looking okay. I basically went into design view of the original table and modified the Field name only, not the data type. And I love the analogy you gave NTC...about the tables field name is the foundation!

[June7]

If the field is referenced in expressions, the change will likely not carry through. I use Rick Fishers Find & Replace add-in for changes like this. Saved my sanity more than once. Cost about $50. There is also a freebie called V-Tools.

[fuecheefang]

If the field is referenced in expressions, the change will likely not carry through. I use Rick Fishers Find & Replace add-in for changes like this. Saved my sanity more than once. Cost about $50. There is also a freebie called V-Tools.

Good point June, I will have to dig back in to make sure the Field Name is not used in expression as well. is Rick fishers still around? I coulda swore I tried looking for the site and they weren't around any longer?

[June7]

Here http://www.rickworld.com/

[fuecheefang]

Here http://www.rickworld.com/

Thank you, June7. Problem is resolved.