Each control has Left and Top properties that determine its position, and Width and Height properties that determine its size. In Visual Basic, they are measured in twips, where 1 inch = 1440 twips. So to position a text box txtSomething one inch from the left side of the form, use

Me.txtSomething.Left = 1440

Or to move it 1/2 inch to the right from its current position:

Me.txtSomething.Left = Me.txtSomething.Left + 720

Each control has Left and Top properties that determine its position, and Width and Height properties that determine its size. In Visual Basic, they are measured in twips, where 1 inch = 1440 twips. So to position a text box txtSomething one inch from the left side of the form, use

Me.txtSomething.Left = 1440

Or to move it 1/2 inch to the right from its current position:

Me.txtSomething.Left = Me.txtSomething.Left + 720

Actually, I am truly a Dallasite now. I used to live in Mckinney, but I moved into Dallas back in April. LONG story.

As to your post, let me try to explain in a more ‘intuitive’ way. VB/VBA is supposed to be an object oriented programming language. This is a touchy subject, because C programmers will harp on the fact that VB does not have inheritence. (VB.Net does, but VB 6.0, and VBA (which is a subset of VB, sort of…VB is also a subset of VBA) doesn’t). Anyhow, there are two types of code within VB/VBA. Objects and Processes. An object has attributes, a process has an outcome. Take for example a form. A form has attributes, such as height, width, background color, etc. A process just has an outcome, like UCase. UCase turns a string into all Caps.

Now, it gets a bit more complicated then that, but processes and objects are the basics. Processes can deal with objects, and objects can have processes. In this particular case, you want to use an objects properties, to create a process, the Left property, to cause the control to ‘float’. Now, we could just do something like this:

Sub Float()
Dim i As Long
For i = 1 To 10
Do Until Me.txtFloat.Left + Me.txtFloat.Width = Me.Width
Me.txtFloat.Left = Me.txtFloat.Left + 1
Screen.ActiveForm.Repaint
Loop
Do Until Me.txtFloat.Left = 0
Me.txtFloat.Left = Me.txtFloat.Left – 1
Screen.ActiveForm.Repaint
Loop
Next i
End Sub

This ‘floats’ a control called txtFloat, from right to left, ten times. This is a process, that changes an object’s attributes. However, it is only doing one control. If you really want to build something to affect all textboxes, let me know, just don’t want to make a 5 page post!

Actually, I am truly a Dallasite now. I used to live in Mckinney, but I moved into Dallas back in April. LONG story.

As to your post, let me try to explain in a more ‘intuitive’ way. VB/VBA is supposed to be an object oriented programming language. This is a touchy subject, because C programmers will harp on the fact that VB does not have inheritence. (VB.Net does, but VB 6.0, and VBA (which is a subset of VB, sort of…VB is also a subset of VBA) doesn’t). Anyhow, there are two types of code within VB/VBA. Objects and Processes. An object has attributes, a process has an outcome. Take for example a form. A form has attributes, such as height, width, background color, etc. A process just has an outcome, like UCase. UCase turns a string into all Caps.

Now, it gets a bit more complicated then that, but processes and objects are the basics. Processes can deal with objects, and objects can have processes. In this particular case, you want to use an objects properties, to create a process, the Left property, to cause the control to ‘float’. Now, we could just do something like this:

Sub Float()
Dim i As Long
For i = 1 To 10
Do Until Me.txtFloat.Left + Me.txtFloat.Width = Me.Width
Me.txtFloat.Left = Me.txtFloat.Left + 1
Screen.ActiveForm.Repaint
Loop
Do Until Me.txtFloat.Left = 0
Me.txtFloat.Left = Me.txtFloat.Left – 1
Screen.ActiveForm.Repaint
Loop
Next i
End Sub

This ‘floats’ a control called txtFloat, from right to left, ten times. This is a process, that changes an object’s attributes. However, it is only doing one control. If you really want to build something to affect all textboxes, let me know, just don’t want to make a 5 page post!