I was wondering is there anyway to wrap the text in the columns? Also, is there a way to adjust the column width automatically? I know how to do it manually, just wondering if it would adjust on its own. :?:

12 Years
Discussion Span
Last Post by GolferGuy

I am assuming you mean with regards to a table?

There is no way to do this, at least that I know of or ever heard of. The tables in access are not like an excel spreadsheet; used for display. Rather they are used to store data


If you want to adjust the width of a column in a form that is in datasheet view (which looks like the table view) you can adjust it automatically by setting the .ColumnWidth to -2. The .ColumnWidth is ONLY available in DataSheet view. In form view the width of a column is set with the .Width property.

To get the data to wrap, you can just make the row, while in datasheet view, taller. this will have to be done manually, as I do not know of any way to do the height with program code.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.