changing labels via VBA

[branston]

Hi,

Is there a way to change the label of a text box via vba?
I am setting up some filters, and 10 of them are set to custom1, custom2 etc. I want the user to be able to define the filter (that bits done) but then change the name from Custom1 to something more meaningfull.

I thought i could do something like 2 input boxes, defining which name wants to be changed and what to, but then i hit a brick wall of how to get the code to actually change the name!

Any ideas?

 

[HiTechCoach]

I would use a text box control size the user can easily edit it

 

[branston]

I guess that would be an easy way round, yeah. I figured out how to make the box change, but i cant make it stay at the new name.
I think I shall just go with yoru way! Thank you!

 

[branston]

Ah, that doesnt work either. If i go out of the form and back in the text boxes have reverted to blank.

Do I have to store the names in a table or somethgn and link them that way?

 

[HiTechCoach]

I re-read your posts several time and you never said that you needed to save the data.

If you want to save the values, you will have to create some place to store the data. I like use a table with a separate record for each piece of data.

I would probably create a form just for editing the data for the labels.. The way I handle this is to have a separate

 

[branston]

I apologise for missing that bit of information out! Ive set up a table now and a bit of code so i can update them and its working well. Thank you.

 

[HiTechCoach]

You're welcome!

Glad we could assist.