PC Review


Reply
Thread Tools Rate Thread

Column width in a subform?

 
 
Rolf Rosenquist
Guest
Posts: n/a
 
      27th Nov 2004
Cannot figure out how to fix the column width of a datasheet in a subform,
so that users cannot change them. Is it not possible to lock it?

/ Rolf


 
Reply With Quote
 
 
 
 
Marshall Barton
Guest
Posts: n/a
 
      27th Nov 2004
Rolf Rosenquist wrote:

>Cannot figure out how to fix the column width of a datasheet in a subform,
>so that users cannot change them. Is it not possible to lock it?



Use the ColumnWidth property (check Help for details).

--
Marsh
MVP [MS Access]
 
Reply With Quote
 
 
 
 
Dale Fye
Guest
Posts: n/a
 
      27th Nov 2004
As Marshall states, you can set their width, but I have never been able to
figure out a way to actually prevent the user from changing the width at run
time. The only alternative I have come up with is to use a continuous form,
put the rows right on top of each other. By doing this, you set the text
box widths at design time and don't have to worry about it after that.

Actually, the only time I use datasheets is when I want to present my user
with a lot of data at one time, and let them figure out what is of use to
them. Using the data sheet also allows them to change the order of the
columns during run time, although they will always come back up in the
format that they were designed in.

HTH
Dale

"Rolf Rosenquist" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Cannot figure out how to fix the column width of a datasheet in a subform,
> so that users cannot change them. Is it not possible to lock it?
>
> / Rolf
>
>



 
Reply With Quote
 
Stephen Lebans
Guest
Posts: n/a
 
      27th Nov 2004
Here is a previous post of mine on this subject.

From: Stephen Lebans
((E-Mail Removed))
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/de.../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.


After reading Michael's article you would then do something similiar
along these lines:

From: Bill Murphy ((E-Mail Removed))
Subject: Re: Freezing columns in a continuous subform


View this article only
Newsgroups: microsoft.public.access.forms
Date: 2004-03-31 13:03:23 PST



Thanks Stephen. In Michael Kaplan's article I found a tip which led me
to
the answer. Here's some sample code that I am using in the load event
of a
data sheet subform which works well:

' Freeze each column needed

Me![Project].SetFocus
DoCmd.RunCommand (acCmdFreezeColumn)

Me![Lender#].SetFocus
DoCmd.RunCommand (acCmdFreezeColumn)

Me![Loan#].SetFocus
DoCmd.RunCommand (acCmdFreezeColumn)

All three columns will be frozen at the left of the data sheet, and the
user
can scroll horizontally for all other columns in the data sheet.

Bill



--

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


"Dale Fye" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> As Marshall states, you can set their width, but I have never been

able to
> figure out a way to actually prevent the user from changing the width

at run
> time. The only alternative I have come up with is to use a continuous

form,
> put the rows right on top of each other. By doing this, you set the

text
> box widths at design time and don't have to worry about it after that.
>
> Actually, the only time I use datasheets is when I want to present my

user
> with a lot of data at one time, and let them figure out what is of use

to
> them. Using the data sheet also allows them to change the order of

the
> columns during run time, although they will always come back up in the
> format that they were designed in.
>
> HTH
> Dale
>
> "Rolf Rosenquist" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Cannot figure out how to fix the column width of a datasheet in a

subform,
> > so that users cannot change them. Is it not possible to lock it?
> >
> > / Rolf
> >
> >

>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Usable Width of a Panel, i.e. Panel.Width - VerticalScrollBar.Width ? eBob.com Microsoft VB .NET 2 16th Apr 2009 07:03 PM
Create a macro which takes a column name and width and sets the column width to what it should be Ag Microsoft Excel Programming 4 29th Sep 2007 11:29 PM
IS IT POSSIBLE TO HAVE A1.J15 COLUMN WIDTH AS 10 AND A15.J30 COLUMN WIDTH TO 15? CAPTGNVR Microsoft Excel Misc 5 5th Feb 2007 11:16 PM
Content width (Control width - scroll bar width) Sin Jeong-hun Microsoft C# .NET 0 17th Nov 2005 08:39 PM
Textbox width scaling to width of data not width of page? AndrewF Microsoft ASP .NET 1 10th Oct 2005 05:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:34 PM.