Auto, Autosizing of column in a table or query

D

DanielWalters6

does anyone know of a way that I make make one, or more query datasheet views
automatically auto-size the column to fit just the data that I currently have
in them.

My query returns addresses in 5 fields, and obviously some times the first
line of the address can be a lot longer than at others.

If you know how to make it automatically auto size all of the columns, (if
you know how to achieve this in a table, that would be a great help too)
Please reply to this post.

Thanks

Dan
 
W

Wayne Morgan

You can do this, to a point, with a form in Datasheet View. The example in
the Help file has this, but it doesn't say what the value does. If you set
the control's ColumnWidth property to -2, it will set the column to Auto
Fit. However, it will auto fit to the widest item in the column, whether or
not that item is currently visible on the screen.
 
Top