Preventing Changing Column Width

[Guest]

I am not sure if this is even the right location for this post. I am fairly new to Access, and have hit a road block that I could use some help with. I have set up a for with a subform in it that is set to datasheet view. I have gotten this all correct, even getting my queries set up, which was a big deal for me. What I could like to know how to do is to set the width of the columns in datasheet view (I know how to re-size them with right click and selecting column with) and make it so that users can't resize these columns. There should never be any need for them to do so, and it causes the bottom scroll bar to apear if they make them to wide. I have 6 columns of data

If anybody can help me with this I would really appreciate it. I have looked at the books that I have, but I can't find anything

Thanks

Dave

 

[Douglas J. Steele]

Sorry, but what difference does it make if your users decide to expand the
fields and the scroll bar appears?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am not sure if this is even the right location for this post. I am

fairly new to Access, and have hit a road block that I could use some help
with. I have set up a for with a subform in it that is set to datasheet
view. I have gotten this all correct, even getting my queries set up, which
was a big deal for me. What I could like to know how to do is to set the
width of the columns in datasheet view (I know how to re-size them with
right click and selecting column with) and make it so that users can't
resize these columns. There should never be any need for them to do so, and
it causes the bottom scroll bar to apear if they make them to wide. I have
6 columns of data.

If anybody can help me with this I would really appreciate it. I have

looked at the books that I have, but I can't find anything.

 

[Guest]

I guess it really doesn't make any difference, it is mainly an appearance thing for the user interface. If it can't be done its not a big deal, I was just curious

----- Douglas J. Steele wrote: ----

Sorry, but what difference does it make if your users decide to expand th
fields and the scroll bar appears

--
Doug Steele, Microsoft Access MV
http://I.Am/DougSteel
(no e-mails, please!

I am not sure if this is even the right location for this post. I a

fairly new to Access, and have hit a road block that I could use some hel
with. I have set up a for with a subform in it that is set to datashee
view. I have gotten this all correct, even getting my queries set up, whic
was a big deal for me. What I could like to know how to do is to set th
width of the columns in datasheet view (I know how to re-size them wit
right click and selecting column with) and make it so that users can'
resize these columns. There should never be any need for them to do so, an
it causes the bottom scroll bar to apear if they make them to wide. I hav
6 columns of data

 

[Stephen Lebans]

http://www.lebans.com/autocolumnwidth.htm

AutoColumnWidth is a Database containing functions to enable auto sizing
of Columns in Form Datasheet view by clicking on the Column Header. Also
contains a class to NOT allow the user to change the ColumnWidths at
runtime.

Access offers this function but only for the rows of the Datasheet that
are currently in view. AutoColumnWidth checks every row of the Datasheet
to calculate the final width required to completely display the contents
in every row.

Version 2.0 - Added support for Column Freezing for ListBox, Combo and
CheckBox controls!

Version 1.8 - Improved implementation thanks to Sandra Daigle!

Version 1.6 - Improved implementation thanks to Elmar Boye!

Version 1.5 - Added method to NOT allow the user to change the Column
Widths at runtime

Version 1.0 - First release


--

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

I am not sure if this is even the right location for this post. I am

fairly new to Access, and have hit a road block that I could use some
help with. I have set up a for with a subform in it that is set to
datasheet view. I have gotten this all correct, even getting my queries
set up, which was a big deal for me. What I could like to know how to
do is to set the width of the columns in datasheet view (I know how to
re-size them with right click and selecting column with) and make it so
that users can't resize these columns. There should never be any need
for them to do so, and it causes the bottom scroll bar to apear if they
make them to wide. I have 6 columns of data.

If anybody can help me with this I would really appreciate it. I have

looked at the books that I have, but I can't find anything.

 

[Dirk Goldgar]

I am not sure if this is even the right location for this post. I am
fairly new to Access, and have hit a road block that I could use some
help with. I have set up a for with a subform in it that is set to
datasheet view. I have gotten this all correct, even getting my
queries set up, which was a big deal for me. What I could like to
know how to do is to set the width of the columns in datasheet view
(I know how to re-size them with right click and selecting column
with) and make it so that users can't resize these columns. There
should never be any need for them to do so, and it causes the bottom
scroll bar to apear if they make them to wide. I have 6 columns of
data.

If anybody can help me with this I would really appreciate it. I
have looked at the books that I have, but I can't find anything.

In addition to Stephen Lebans' technical solution (no doubt brilliant as
usual), you could simply use a continuous form view rather than
datasheet view for the subform, formatted to look as much like a
datasheet as you want.