CODEWITHSUNDEEP
ms-access-2007reporting
NoChance
NoChance

Reputation: 5752

MS-Access form, want text to wrap without truncation (as in reports)

I have a form that shows a list. One of the fields is of type text, with max. length of 255. This field appears truncated on the form. The Can Grow property is set to 'Yes'.

I want the height to be dynamically adjusted in each row based on the number of characters in the current filed. This happens in reports but not in form fields in this case.

I tried to compare the properties in the form with the report but could not spot a difference.

How can I do that please? Thx.

enter image description here

Upvotes: 1

Views: 908

Answers (1)

Andre
Andre

Reputation: 27634

No chance (scnr), This property doesn't work in form view, only if the form is printed.

TextBox.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.

Edit

You can take a look at http://lebans.com/cangrow.htm

Stephen Lebans is an API wizard, you will find lots of complicated code in there, but it may do what you want. But you'll have to decide if it's worth the additional code and potential instabilities.

Upvotes: 1

Related Questions