Change All Label Captions within a Form

[silentwolf]

Hi oh ok well I will look into it thanks for your reply!

Cheers

 

[CJ_London]

After you change the caption of your label, use the Refresh-method of the
label to get it to repaint itself.

That is not correct. Refresh is to do with the underlying data, not captions. It also happens automatically - typically 60 seconds as the default set in Options>client settings and is really only relevant in a multi user environment as it reflects changes in the current recordset made by other users.

Refresh differs from requery in that it looks at changes to the current records whereas requery will reapply any criteria and may add or remove records accordingly.

 

[silentwolf]

Ah ok..

Thanks CJ_London for explaining!

 

[silentwolf]

Ok I am changing slowly lol

Getting alot of not that great feetback of using prefixes and so I did in new application get rid of it

Cheers

 

[The_Doc_Man]

Hi Doc_Man,

thanks for your input too.

I am a little lost with what you mean exactly.

Also with CJ_London I do have a little difficulty to understand how to set it up correctly.
As mentioned it is a bit akward how I do it or done it.

Cheers

Sorry I'm a little late in replying.

What I meant was that if you did a "for each ctl in forms.controls" type of loop, you would know which control was associated with a label because the .Parent of a label is the control that owns it, whereas the .Parent of some other control is usually the form itself. I can't be certain, but I think most cases of controls are such that they have either a caption or a value but not both. The option group & option button get a bit complex about this, but most other controls do follow that general rule of having one or the other but not both. Controls also exist that have neither a .Value nor a .Caption - e.g. rectangles or lines. So that "for each" loop would do best to verify the control type of the control it was seeing at the moment anyway.

 

[silentwolf]

Hi Doc_Man

all good, I sometimes oversee it to and then I reply way to late so no problem at all!

But thanks for taking it on again and explaining it a little better, well explaining it so I understand it

Very much appreciated!

Cheers