C
CJ
Is there any way to use VBA code to minic the Format>Column Width>Best Fit
menu and address all the columns in a datasheet/table?
menu and address all the columns in a datasheet/table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dirk Goldgar
CJ said:Is there any way to use VBA code to minic the Format>Column
Width>Best Fit menu and address all the columns in a datasheet/table?
Not easily, AFAIK, but Stephen Lebans has something like that on his web
site at
http://www.lebans.com/autocolumnwidth.htm
S
Stephen Lebans
My standard reply to Datsheet formatting issues is:
For programmatic control of 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/dnsmart
01/html/sa01b1.asp
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.
For programmatic control of 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/dnsmart
01/html/sa01b1.asp
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.
C
CJ
Thanks for the information. I tried Michael Kaplan's code. Works good for
my current application.
my current application.