Datasheet column widths

[Guest]

Is there a way to prevent the user from modifying the width of columns in
datasheet view. For example, I have a form and I do not want the user to be
able to resize the columns on the form so that it will fit nicely on the
screen.

Thanks!

 

[Guest]

I do not know how to lock widths but you could create an Event or Macro to
set widths when they exit the form.

 

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