Table Row Sizing

[Rosemary]

Hi,

I have what might be a simple question: I have a table
with a field that is a memo datatype. The table is
displayed as a subform on my main form, and lists the
records in datasheet view. Some records are long
entries, and some are short. Can I get the rows in the
table (and its subform) to size automatically to fit the
amount of text entered? Right now, the rows are very
wide so they can display the largest entries (a paragraph
or more), which leaves a lot of white space on the form
when text in a row is short.

Thanks!
Rosemary

 

[Albert D. Kallal]

No, you can't get them to re-size differentially (they all must be the same
size).

You can use a continues form in place of a data sheet, and have the text box
a few lines in size...but then all will be this size...

 

[Ken Snell [MVP]]

Assuming that you're not using a datasheet view and instead are using a
continuous forms view, simply "turn on" the vertical scroll bar in the
textbox that holds the memo text. Then the user can scroll down within the
textbox to see the rest of the text.

 

[Rosemary]

Albert and Ken,

Thank you both very much.

Regards,
Rosemary