Automatically resize textbox height to fit contents on form

In Access 2007, I'm using bound textboxes on a continuous form to display the contents of each record's memo field. Is there a way to automatically adjust the textbox height to fit the contents?

Thanks in advance.

re: Automatically resize textbox height to fit contents on form

No, there is no way to "automatically" do this. I think it would require some rather complicated code, wherein you figure, given your font size and width of your memo field's textbox, how many characters could fit in a line, how many lines you need and set the height accordingly. And after doing all this, on a Continuous form, when you change the height of the textbox on RecordA, the height of the textbox on all records would be changed!

A better solution would be to allow the user to expand the textbox on a given record, using the acCmdZoomBox command. You could use this in a number of events, but the DoubleClick event is frequently used

as well as the GotFocus event.
Welcome to Bytes!

Linq ;0)>