Lock Column Width in Datasheet view?

  • Thread starter Thread starter Dale Lundgren
  • Start date Start date
D

Dale Lundgren

Is it possible to keep the user from adjusting the Column Width in datasheet
view of a form?

Thanks in advance,

Dale Lundgren
 
Dale,

Not really. You lose almost all control when you use a datasheet form. What
I always do when I need one is to create a form that will look like a
datasheet when it is displayed in form view. They can't change anything then
and you now have access to all form events.

Gary Miller
 
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