How to a bound textbox on a form grow

[Guest]

Hi all,

I have a bound textbox on a form and the control may contain large number of
chars from a table. My method is to set its Can Grow property, but it doesn't
work.
How can I handle it?

Clara

thank you so much for your help

 

[missinglinq via AccessMonster.com]

CanGrow is only avaiable in Reports, not on Forms! Sorry! One way to handle
large amounts of data in a textbox is to use the ZoomBox. This code "expands"
the textbox when you double-click on it:

Private Sub YourTextBoxName_DblClick(Cancel As Integer)
DoCmd.RunCommand acCmdZoomBox
End Sub

You can also use it to enter a large amount of data without having it scroll
out of site!

 

[Guest]

Hi AccessMonster,
Thank you very much for your answer. Let's look the problem from the other
side. If the textbox is bound to a large field in a table and when ii is
filled with the data, how does it tell that the data is too long to fit and
acivate the zoombox code.

Clara

thank you so much for your help