Add a label to a form programmatically?

[aaea73]

Hi,

I wonder if someone can help me with a script that programmatically adds a label control to an existing MS Access form.

Thanks for any help,

aaea73

 

[Shake412]

Can't you create the label control in design mode and set the visible setting to false, then set it to true programmatically when required?

 

[aaea73]

Shake,

Yes, I've thought about that solution, but I want to insert many labels in the form and I don't know how many of it will be needed at deign time. Any ideas?

Thanks

 

[Shake412]

Sorry I can't find any solution to this one. I'll look again this afternoon. If you get anywhere, let me know. Good luck.

 

[FancyPrairie]

Below is how you create a label. However, the form must be in design view in order to create the label.

Set ctlNew = CreateControl(Forms("form1&quot.Name, acLabel)