Subform - preventing changes to column width

  • Thread starter Thread starter gb
  • Start date Start date
G

gb

Hello

My main form includes a subform with three columns. I want to prevent users
from using the mouse to change the width of any of the columns in the
subform.

How can I do this, please?

Thank you

gb
 
Hello

My main form includes a subform with three columns. I want to prevent users
from using the mouse to change the width of any of the columns in the
subform.

How can I do this, please?

Thank you

gb
Click to expand...

Don't use Datasheet forms, use Continuous Forms.

- Jim
 
gb said:
Hello

My main form includes a subform with three columns. I want to prevent users
from using the mouse to change the width of any of the columns in the
subform.

How can I do this, please?

Thank you

gb
Click to expand...

I think you need to SubClass, but it's a very hard way.
You can you a Continuos SubForm instead that Datasheet view.
The Results are very similar, and you have not the Column Resize
problem....!

Bye.
 
Here is a previous post of mine on this subject.

From: Stephen Lebans
([email protected])
Subject: Re: Freeze Column?
View: Complete Thread (3 articles)
Original Format
Newsgroups: microsoft.public.access.forms,
microsoft.public.access.formscoding,
Date: 2003-12-24 11:53:00 PST

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