colum width in datasheet view

[Beth]

I have a subform in datasheet view. Is there a way to lock the columns so
that users can't resize the columns?
thanks,
Beth

 

[Guest]

Hi,
no...there is no real simple way of just locking the column width.
One way you can go about this though is to just resize the column width on
whatever events to your desired width (.ColumnWidth = ...). This would let
the user resize them, but they would automatically go back to their original
size right afterwards. You might also find these helpful:

http://www.lebans.com/autocolumnwidth.htm
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart01/html/sa01b1.asp
HTH
Good luck