Controlling the column widths in a form shown as datasheet

[Guest]

How can I control the width of the columns when for instance a form show data
in the datasheet view. I want to have the columns just as wide as the wides
string of characters in any record. I know i can put the mousepointer between
the columns and doubleclick for adjust. But thats just temporary. I want to
control the width in advance.
Martin Bolbroe
www.titit.dk
Denmark

 

[Alex Dybenko]

Hi,
you can use a columnwidth property to change width of a column. I think you
can find a sample how to calculate column width for list box at
www.lebans.com, so you can use the same approach for datasheet

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thanks for the tip but it doesn't seem to work out as expected. I seem to
have trouble with differences between Acc97 and ACC2003.
Do you really have to write code to control the column width. At least I
think you can double click with the mouse pointer so why can't you just call
this function from somewhere?

Martin Bolbroe
www.titit.dk
Denmark

 

[Alex Dybenko]

Hi,
do you mean this one:
http://www.lebans.com/autocolumnwidth.htm ?
what is not working there?

as for call access function to autosize - i dont know if this is possible

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

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