Move Multiple Fields on a Form

[Ray Stantz]

Hi all, i am aware of the method used to move a control to the left or adjust its height/width but is there a way to move fileds down to a specifc location using VBA? I've looked everywhere but couldn't find an answer.


Thanks.

 

[SOS]

Hi all, i am aware of the method used to move a control to the left or adjust its height/width but is there a way to move fileds down to a specifc location using VBA? I've looked everywhere but couldn't find an answer.

For a control:

Me.YourControlName.Left = ValueInTwips
Me.YourControlName.Top = ValueInTwips

You have to give it the value in twips (1440 to an inch). So, I make it easy on myself. For example I will go:

Me.YourControlName.Left = 3 * 1440
Me.YourControlName.Top = 2.25 * 1440

 

[Scooterbug]

use the Left and Top property. For example:

me.text1.left = 1000

Note:
In Visual Basic, use a numeric expression to set the value of this property. Values are expressed in twips (twip: Unit of measurement that is equal to 1/20 of a point, or 1/1,440 of an inch. There are 567 twips in a centimeter.).

Check the help in the VB editor for more details

 

[Ray Stantz]

Perfect! Thank you both for your quick response.