Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2005

Tip: Looking for answers? Try searching our database.

Multiple Columns on Form??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David - 30 Jul 2005 13:47 GMT
Is it possible to create 2 or 3 columns on a form?  I have a form with a
single field in the Detail Section and an Option Group/various buttons in the
Form Footer. Instead of scrolling the detail section up/down in Form View
mode; I would prefer to contain the whole dataset in multiple columns across
the upper portion of the page.   I changed the Page Set-Up to 2 columns but
that only works for printing.  Any way to do this?
Sprinks - 30 Jul 2005 14:04 GMT
David,

You can place controls anywhere you want on your forms, including in a
multi-column arrangement.  Either pick & drag a control into place, set the
Left and Top properties manually, or, more efficiently, use the Format, Align
command to align a set of controls all at once, and the various Format,
spacing commands that space them evenly.

The order in which the cursor moves from one control to another is
determined by the control's Tab Order property.  The most efficient way to
put them in order is View, Tab Order, and drag the fields into the order in
which they appear on screen.  If you select Auto Order, they will go left to
right, then top to bottom.

Hope that helps.
Sprinks

> Is it possible to create 2 or 3 columns on a form?  I have a form with a
> single field in the Detail Section and an Option Group/various buttons in the
> Form Footer. Instead of scrolling the detail section up/down in Form View
> mode; I would prefer to contain the whole dataset in multiple columns across
> the upper portion of the page.   I changed the Page Set-Up to 2 columns but
> that only works for printing.  Any way to do this?
DavidSt - 30 Jul 2005 14:19 GMT
Maybe I am missing something here....how do you create a multiple column
arrangement in a form?  

> David,
>
[quoted text clipped - 19 lines]
> > the upper portion of the page.   I changed the Page Set-Up to 2 columns but
> > that only works for printing.  Any way to do this?
Rick Brandt - 30 Jul 2005 16:05 GMT
> Maybe I am missing something here....how do you create a multiple
> column arrangement in a form?

Multiple controls that expose a single record can be arranged in columns.
Multiple *records* can only be shown in a single column.  It might be posssible
to kludge something together with multiple subforms, but my guess is that it
would be complicated and problematic.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Sprinks - 30 Jul 2005 18:28 GMT
Sorry, David; I didn't read carefully.  My only suggestion would be to try
Steven Lebans website; if anyone would have the patience and talent to tackle
this Access inadequacy, it'd be him.

www.lebans.com

Sprinks

> Maybe I am missing something here....how do you create a multiple column
> arrangement in a form?  
[quoted text clipped - 22 lines]
> > > the upper portion of the page.   I changed the Page Set-Up to 2 columns but
> > > that only works for printing.  Any way to do this?
Albert D.Kallal - 31 Jul 2005 23:07 GMT
A good solution is to use sub-forms. Here is some screen shots of having
some controls, and some others show "many" records of the one record.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Signature

Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.