Controlling the column widths in a form shown as datasheet

M

mbolbroe

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
 
M

mbolbroe

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
 
S

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