datasheet view needs memo field to grow with data.

S

Steve

I have a main form with a subform in datasheet view. The subform is used to
display comments about the client on the main form. My problem is that the
comment field (memo data type) is not growing when the text won't fit. It
gives me scroll buttons instead. I have the can grow property of the field
set to yes, is there someplace else I need to address to make the field grow?

TIA for the help.

Steve
 
D

Damon Heron

This only reveals itself on reports or forms printed or previewed.
I have had similar problems with memo fields containing too much info and I
use the double-click event to
show a zoombox to view the entire contents.

Damon
 
J

John W. Vinson

I have a main form with a subform in datasheet view. The subform is used to
display comments about the client on the main form. My problem is that the
comment field (memo data type) is not growing when the text won't fit. It
gives me scroll buttons instead. I have the can grow property of the field
set to yes, is there someplace else I need to address to make the field grow?

TIA for the help.

Steve

Datasheets are VERY limited in their flexibility, and this is one of those
limitations. You can press Shift-F2 while a datasheet field has the focus to
pop up a zoom box, or (perhaps better) provide a Continuous Form with either a
bigger textbox or a textbox with a scrollbar.

There's no easy way (with either continuous OR datasheet OR single) forms to
have a textbox shrink and grow as you type, though.
 
S

Steve

Not true in my case. This is happening in the subform when the main form is
open.

Thanks

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top