Controlling the column widths in a form shown as datasheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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