Open your form in design view and select txtComments. Click on the
Properties button in the menu and go to the Format tab. Look at the Top,
Left, Right and Height properties and make note of what they are. Now go to
the Events tab and start a procedure in the MouseOver event. Enter this code
to enlarge the height of txtComments 1/2' and the width of txtComments by
2":
Me!txtComments.Height = Me!txtComments.Height + 720
Me!txtComments.Right = Me!txtComments.Right + 2880
Note: Although these properties are shown in inches in Format Properties,
they are actually stored internally in Twips where 1 Twip = 1/1440".
Therefore 1/2" = 720 Twips and 2" = 2880 Twips.
Put the following code in the mouse move off event:
Me!txtComments.Height = Me!txtComments.Height - 720
Me!txtComments.Right = Me!txtComments.Right - 2880
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]