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 tables or queries, pretty much so. You do have "Can Grow" and "Can Shrink"
options in reports and forms.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"maggie" wrote:

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

maggie wrote:
> 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.

--
Joseph Meehan

Dia 's Muire duit

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

"Jerry Whittle" wrote:

> In tables or queries, pretty much so. You do have "Can Grow" and "Can Shrink"
> options in reports and forms.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
> "maggie" wrote:
>
> > 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?

On Fri, 6 Jul 2007 16:38:03 -0700, roccogrand
<(E-Mail Removed)> wrote:

>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]