rename a control

[peljo via AccessMonster.com]

Can i rename a control on the fly ? For example, if Me!Office = 6 Then Me.
Branch9 = Me!Branch. Both branch9 and branch are fields in the table products

 

[Jeanette Cunningham]

Hi Peljo,

The code you posted does not rename the control.

It makes the value for the control called Branch equal to the value of the
control called Branch9, assuming that Branch9 and Branch are both controls
on your form.

It is unusual to have a field for both Branch and Branch9 on a form.
Usually there would be a field for Branch, the value for Branch would be
recorded for each record in the table.
If you can tell us what you are trying to do on your form, we may be able to
suggest an alternative.

Jeanette Cunningham

 

[Alex Dybenko]

Hi,
you need to open form in design view, and then use .Name property to change
control's name

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com