Freeze Column?

  • Thread starter Thread starter Ashish Kanoongo
  • Start date Start date
A

Ashish Kanoongo

How do I freeze column programmatically or prevent resizing of column at runtime in datasheet view?
I dont want to use right click, so I 'No' to shortcutmenu at form properties.
 
<DIV><FONT face=Arial size=2>How do I freeze column programmatically
or prevent resizing of column at runtime in datasheet view?
</FONT></DIV>
Click to expand...

Just don't do that: forms were invented for displaying and updating records
so use them. If you really like the grid format, then it is easy enough to
set up a continuous-forms form in a similar layout.

HTH


Tim F
 
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.


How do I freeze column programmatically or prevent resizing of column at
runtime in datasheet view?
I dont want to use right click, so I 'No' to shortcutmenu at form
properties.
 
Back
Top