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. :?:
djbsabkcb 0 Junior Poster in Training
Paladine 138 Master Poster Team Colleague
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
djbsabkcb 0 Junior Poster in Training
Thanks, didn't think so.
miketillman 0 Newbie Poster
read the text to a buffer and then format it?
GolferGuy 0 Newbie Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.