Datasheet Column Width

[ADixon]

Hi all

I have a datasheet as a subform. Is there any way i can set the column
widths to automatically refresh to the width of the contents when re-queried?
I've found various solutions elsewhere (set datasheet's ColumnWidth property
to -2, using the fields Tag property, etc) but none seem to work.

In anticipation...

 

[Arvin Meyer [MVP]]

In your requery code, set the columnwidth property of each column to -2