Auto, Autosizing of column in a table or query

[Guest]

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

 

[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.

 

[Guest]

okay, thankyou it's definately something I will look at.

Dan