Can words wrap in a column

[Pam Walkup]

Can words wrap in a column - the comments/memo column?

 

[Jeff Boyce]

Pam

It sounds like you are trying to see the kind of word-wrap you'd see in a
Word table. If you are working directly in an Access table, stop! Access
tables store data, Access forms display data. Use a form to get a text
control that lets the words wrap.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BruceM]

Words can wrap in Access forms and reports, but you'll have to provide more
information. For starters, what do you mean by "comments/memo column"? In
a table or query you can make the rows taller, which will allow text to
wrap. Unlike Excel, all rows in an Access table or query are the same
height. However, you shouldn't be using tables for anything other than
storing data. To control the display format, use a form or report.

 

[Pam Walkup]

In the table, we have columns such as name, contact, status, date, and
comments. In the comments column, my executive would like the words to wrap
around for viewing & printing purposes.

Thx.

Pam

 

[Rick Brandt]

In the table, we have columns such as name, contact, status, date, and
comments. In the comments column, my executive would like the words
to wrap around for viewing & printing purposes.

On Reports if you set the TextBox used to display the field to CanGrow = Yes
then it will wrap the text and grow vertically as required. You cannot get
that behavior when printing the table datasheet directly.