Access: Table Column Width

[gheyman]

I have a Split form where the table format is shown on the bottom half of the form. Is there a way to "autofit" or size the columns size when the form is refreshed or opened?

 

[xenou]

I've never seen this, not that it isn't possible. The way I remember forms with data tables, column widths are consistent - basically, they stay the same as what they were last time (assuming you allow the form to save this information). Is that not good enough?

 

[Micron]

I think you will find that if you open the form and double click on the column border, it will resize to the widest content in the view. If you scroll down and find a field with a wider line and do that again, it will go wider. Conversely, go back to a view where the widest line is less than the last view, it will resize smaller to the widest line in that view. I've seen questions on this before and I don't recall if there were any viable solutions. If there were, they must have involved getting the longest character length in a given field (or worse, fields) and sizing according to that.Who knows where that record is? Due to the nature of how it works, I think it's a pretty useless exercise to adjust to a width for data that's not in view. This would also mean horizontal scrollbars come in to play. A user might ask why the scroll bar when everything (that is visible) is so narrow. Best to just double click on the column border as needed.