Datasheet column widths

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

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!
 
I do not know how to lock widths but you could create an Event or Macro to
set widths when they exit the form.
 
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.
 
Back
Top