colum width in datasheet view

  • Thread starter Thread starter Beth
  • Start date Start date
B

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
 
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
 
Back
Top