How to a bound textbox on a form grow

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

clara - 16 Mar 2007 19:58 GMT

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

Reply to this Message

missinglinq - 16 Mar 2007 21:29 GMT

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!

Signature

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

Answers/posts based on Access 2000

Reply to this Message

clara - 19 Mar 2007 14:15 GMT

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

> 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"
[quoted text clipped - 6 lines]
> You can also use it to enter a large amount of data without having it scroll
> out of site!

Reply to this Message