Lock Column Width in Datasheet view?

[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

 

[Gary Miller]

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

 

[Dale Lundgren]

Thanks Gary. I thought the Datasheet view was too easy

Dale

 

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