Hello! I have a subform that contains a text box. (It is actually a memo in the database). I have to manually scroll to see the entire text of the message! Is there any way to INCREASE the height of this text box so ALL of the text can be seen? Remember, it's in a subform.

Thanks in advance!:D

How is your form view design. Datasheet view or form View ?

Jaime E. Maccou

Form view. Thanks!

How much of the field you can see depends on the size and shape of your form and subform. You can resize the size of that field to anything you want as long as there's room for it on-screen.

There are a couple of things you can do for fields that don't show entirely. You can turn the horizontal scroll bar ON so people can read the whole thing by scrolling. This is the most common way. For really large amounts of text, the user can press SHIFT+F2 key combo and that will open a zoom box with adjustable font size. But again, the zoom box will have a horizontal scroll bar.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks Greg. I would have liked that much to appear WITHOUT using the shift-F2 key, but I guess that will work. Resizing the text box on the form doesn't help. I still get only one line of display.

Thanks for your help.

Open the form in Design view.

Select the text box, and then click Properties on the toolbar.
Set the CanGrow or CanShrink property to Yes.

Jaime E. Maccou