No Resize Please!!!!

[Guest]

I got a form which is displayed in datasheet view
It is used as a subform
How to prevent user from resizing the width of the column?

Any solutions?

Thanks in advance

Kennykee

 

[Stephen Lebans]

Here is a previous post of mine on this subject.

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/libr­ary/default.asp?url=/library/e­n-us/dnsma
rt01/html/sa01b1.asp

2) An API solution is here:
http://www.lebans.com/autocolu­mnwidth.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.

 

[Guest]

I can't enter the web site!!!!!!!!!!!!!!!!!!!
The address is incorrect!!!!
Please retype the address

Thanks

Kennykee

 

[Stephen Lebans]

It's just line wrapping in your Newsreader. Obviously the URL needs to
be all on one line. Place your cursor at the end of the first line and
press the DEL key.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.