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

 

[Stephen Lebans]

For programmatic control for forms in Datasheet view my standard response
is:

1) Michael Kaplan has an excellent article on manipulating Datasheets here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsm...


2) An API solution is here:
http://www.lebans.com/autocolumnwidth.htm
The AutoSizing project also contains a method to FREEZE the ColumnWidths.



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.