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

[Guest]

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?

 

[Guest]

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

 

[Joseph Meehan]

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?

In excel everything happens in the spreadsheet. In Access different
things happen different places.

Tables store data and field definitions, not really designed to view the
data.

Forms and Reports are viewing and printing tools.

Queries are tools to sort and filter data.

 

[Guest]

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

 

[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?

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

John W. Vinson [MVP]