Rename Access labels in a form

[babyatx13 via AccessMonster.com]

I have a database that someone else created. I have several forms that have
lots of labels on them that are attached to code. Not all forms are uniform
and I want to make them that way. Instead of moving each label around I
deleted the whole lot and copied the format I want from another form into the
new form. The new label names don’t correspond with the old labels code. Is
there a way I can rename the labels programmatically instead of changing each
individual name?

thanks KB

 

[Marshall Barton]

I have a database that someone else created. I have several forms that have
lots of labels on them that are attached to code. Not all forms are uniform
and I want to make them that way. Instead of moving each label around I
deleted the whole lot and copied the format I want from another form into the
new form. The new label names don’t correspond with the old labels code. Is
there a way I can rename the labels programmatically instead of changing each
individual name?

Yes, but, while it may be a useful learning experience, the
first time could take more effort than mabually changing
each name. If you do want to create a helper wizard like
procedure, then you must have an algorithm that can be used
to translate between the old names and the new names.


If the code is the same in both forms, maybe you should
consider copying the code too??

 

[Larry Linson]

Yes, but, while it may be a useful learning experience, the
first time could take more effort than manually changing
each name. If you do want to create a helper wizard like
procedure, then you must have an algorithm that can be used
to translate between the old names and the new names.

Whether a Helper Wizard would be feasible or not would depend on the
consistency of the original names and the consistency of the new names. For
making multiple changes, if the names are consistent, it might be worthwhile
to obtain a third-party tool such as Rick Fisher's Find and Replace
(http://www.rickworld.com) or Speed Ferret (http://www.moshannon.com). If I
remember correctly, Speed Ferret was not updated for Access 2003, so could
not be used with Access 2003 unless you had Access 2002 also installed on
the machine. Both of these had user interface changes that were, in my
not-so-humble opinion, "not for the better" compared to earlier versions,
but both were usable.

But writing your own Helper Wizard would definitely be more fun!

Larry Linson
Microsoft Office Access MVP

 

[babyatx13 via AccessMonster.com]

Thank you both for your input it is greatly appreciated.
All the code is the same for all the forms so the labels need to match the
code.
I am just numbering the labels.

Ex. Lable0, Label1, Label2 etc….

I am on a time limit though so I guess I’ll just do them one at a time.

Thanks again
KB

[quoted text clipped - 6 lines]

procedure, then you must have an algorithm that can be used
to translate between the old names and the new names.

Whether a Helper Wizard would be feasible or not would depend on the
consistency of the original names and the consistency of the new names. For
making multiple changes, if the names are consistent, it might be worthwhile
to obtain a third-party tool such as Rick Fisher's Find and Replace
(http://www.rickworld.com) or Speed Ferret (http://www.moshannon.com). If I
remember correctly, Speed Ferret was not updated for Access 2003, so could
not be used with Access 2003 unless you had Access 2002 also installed on
the machine. Both of these had user interface changes that were, in my
not-so-humble opinion, "not for the better" compared to earlier versions,
but both were usable.

But writing your own Helper Wizard would definitely be more fun!

Larry Linson
Microsoft Office Access MVP