No Resize Please!!!!

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

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
he
http://msdn.microsoft.com/libr*ary/d...y/e*n-us/dnsma
rt01/html/sa01b1.asp

2) An API solution is he
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.


"kennykee" wrote in message
...
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

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

Thanks

Kennykee

"Stephen Lebans" wrote:

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
he
http://msdn.microsoft.com/librÂ*ary/.../eÂ*n-us/dnsma
rt01/html/sa01b1.asp

2) An API solution is he
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.


"kennykee" wrote in message
...
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

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.


"kennykee" wrote in message
...
I can't enter the web site!!!!!!!!!!!!!!!!!!!
The address is incorrect!!!!
Please retype the address

Thanks

Kennykee

"Stephen Lebans" wrote:

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
he

http://msdn.microsoft.com/librÂ*ary/...ry/eÂ*n-us/dns
ma
rt01/html/sa01b1.asp

2) An API solution is he
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.


"kennykee" wrote in message
...
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