How to auto adjust access subform field length

[tahirsatti]

I am facing some problem regarding ms access subform.I have four fields in sub form and i want the width and height of filed auto adjusted as per user entry e.g if user enter text of one line then there is no change in size but if user enter text of more then two lines then text items width automatically changes according to the length of text entered by user.

 

[Peter Reid]

I've yet to use it but I have a similar problem and have been looking at http://www.lebans.com/textwidth-height.htm which looks like it may help

 

[GT_engineer]

click on the text box, open the properties, under the Format tab near the bottom there are two options:

Can Grow
Can Shrink

make sure both are Yes.

The boxes will grow or shrink depeneding on the amount of characters.

using the same option on reports will actually make the text box disappear if there is no entry.

 

[tahirsatti]

I use can grow option and also above mentioned api but both are not fullfilling my requirment as for as concern of text item auto size.When i use api then i receive stack overflow message for long text.Please help to resolve this error.
Thanks

 

[GT_engineer]

I see what you mean, the grow/shrink option works for reports but not with forms. I unfortuantly can not help you with the api code.