Create control using Code

[Kib]

Hi, I was wondering if anyone could help me, I am trying to figure out a way to create/add a control to a form in VBA. Such as a Text Box or Label, etc. So if something happens, it will add a new control to the form, and in the code give all the desired properties. Thanks.
-Kib

 

[jebry]

Hi!

You can not add a control to a form in form view. This means that you cannot add a control using VBA which is run, or initiated, from the form you want to add the control to. You can add a control to any form not presently open through code by first opening it in design view and using the create control function. You can then set the properties of the new control and open the form in form view.

hth
Jeff Bridgham

 

[MichaelRed]

Dim ctlText As Control

Set ctlText = CreateControl(frm.Name, acTextBox, , "", "", _
intDataX, intDataY)

Works for me.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[Craig0201]

Kib,

Can only create controls that are members of control arrays. This means that it will inherit the properties of the original control and it must inherit the code of the original.

Craig

 

[Sawatzky]

Dear Kib,

you could put the desired control on the form and set its visible property to false and if you want to have it shown, you can set the visible property to true.

regards Astrid

 

[Eldaria]

I go with Sawatzky, this is what i usuall do, it get's a little messy in the design view, but it works..
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.