Access 2010 Textbox Size 1

[Ray1127]

I have a form in Microsoft access 2010 on the Form is a textbox control with the Control Source set to a text field in the table. Field size is 255 characters. Most of the records the Field contains < 50 characters but a few are > 150. For those I have the text box Can Grow set to Yes. But the text box never changes. Is there another property I need to set so the text box will actually Grow based on field size or am I missing something else?

 

[Gammachaser]

I bet the answer lies in the VB Help for the CanGrow Property:

This property affects the display of form sections and controls only when the form is printed or previewed, not when the form is displayed in Form view, Datasheet view, or Design view.

If you are trying to use it when doing data entry or display in Form or DataSheet View, you are out of luck.

 

[lameid]

Ray,

You may also need to set the can grow property of the section the control appears in.

A side note, generaly if I turn on Can grow, I turn on Can Shrink unless I have good reason not to.

 

[lameid]

Actually forget I said anything.... I instantly was thinking about reports where those properties apply not so much to forms.

 

[Ray1127]

Thanks all, After I posted this I found the information in VB Help as gammachaser pointed out. I've used Can Grow a Lot but after reading that I thought back and realized I'd never used it on a form always in a report. Oh well.