Restrict Column Widths in Datasheet View

[Michael]

I have Sub-Forms in Datasheet view on Forms that are in
Form view - but I would like to be able to set the column
widths of the Datasheet and prevent the user from being
able to change them.

If I put the Sub-Form in Form View I can control Record
Selectors, Scroll Bars, field sizes and so forth. But
once the Sub-Form is set to Datasheet view all those
options, though still available, have no effect. I don't
mind the Record Selectors so much, but I would really
like to be able to set the column widths when I design
the form and prevent the user from altering them.

Anyone know a way to do this?

Thanks,

 

[Ken Snell [MVP]]

No. Use a Continuous Forms view with textboxes arranged directly adjacent to
each other and labels on top of the textboxes. This will give similar
appearance to datasheet view but give you control over the display.

 

[Stephen Lebans]

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.