How do I change the height of individual rows in Access 2007?

M

maggie

I am importing an Excel spreadsheet into Access and one of the columns
contains a description. I want each row to auto-fit to the amount of data in
it, like it does in Excel but can't seem to figure it out. It seems that in
Access every row must be the same size. Is this true?
 
J

Jerry Whittle

In tables or queries, pretty much so. You do have "Can Grow" and "Can Shrink"
options in reports and forms.
 
R

roccogrand

Hi Jerry,
I can get fields on a report to grow by setting the property to Yes but I
have never been able to have fields on a form grow or shrink. Is there a
trick to this?

My text fields are stacked on a main and a subform.

Thanks.

LDN
 
J

John W. Vinson

Hi Jerry,
I can get fields on a report to grow by setting the property to Yes but I
have never been able to have fields on a form grow or shrink. Is there a
trick to this?
Click to expand...

CanGrow and CanShrink apply to forms only when you *print* the form.

John W. Vinson [MVP]
 
Top