Mouse Over

[Guest]

Hello, I have a form that has a address text box. The box isnt big enough to
show all the information so I would like to make the box get larger when I
mouse over it. How is this done? Can you explain in detail I am fairly new to
Access..

Thanks
Chad

 

[Arvin Meyer [MVP]]

Hello, I have a form that has a address text box. The box isnt big enough
to
show all the information so I would like to make the box get larger when I
mouse over it. How is this done? Can you explain in detail I am fairly new
to
Access..

You'll need to code 2 events, the MouseMove for the textbox, and the
MouseMove for the Detail section. The code would be something like:

Private Sub txtAddress_MouseMove(Button As Integer, Shift As Integer, X As
Single, Y As Single)

Me.txtAddress.Width = 2880 ' 2 inches

End Sub

Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As
Single, Y As Single)

Me.txtAddress.Width = 1440 ' 1 inch

End Sub

Form measurements are in Twips. A twip is a twentieth of a point. There are
1440 twips to the inch (72 * 20)