column sizing in Access

[rfjanssen]

is there a way to have the columns automatically size themselves to best fit
in Access 2007? Seems like such a simple thing shouldn't have been omitted.
Bob Janssen

 

[Dirk Goldgar]

is there a way to have the columns automatically size themselves to best
fit
in Access 2007? Seems like such a simple thing shouldn't have been
omitted.
Bob Janssen

See if this has the answer you want:

http://www.lebans.com/autocolumnwidth.htm

 

[Brent Spaulding \(datAdrenaline\)]

In VBA you can set a property named ColumnWidth to the value of -2 in order
to set the column width of a control shown in datasheet view to its optimal
width for the displayed data ... note I said the DISPLAYED data.