Access 2007 Can Grow Property

[Guest]

I am trying to use the Can Grow property in Access 2007. I have a tabular
form with one of the columns Can Grow property set to YES, yet the field does
not grow and chops the end of the text of.

Any ideas?

 

[missinglinq via AccessMonster.com]

The CanGrow function only works in printing! The best you can do in a form,
besides making your box big enough to show your maximum length text, is
something like this with acCmdZoomBox:

Private Sub YourTextBox_MouseMove(Button As Integer, Shift As Integer, X As
Single, Y As Single)
If Not IsNull(YourTextBox) Then
YourTextBox.SetFocus
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you don't want the box always zooming, place in in your textbox's
DoubleClick Event instead, and omit the line

YourTextBox.SetFocus

Hope this helps!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com