 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2006Multi-column form
Hi I have a query (which I have also done as a 'make-table' - if that makes it easier) that I want to display on a form. The fields are Assistant, Sales, Qty etc and I would like to display them in this format: Assistant 10 11 12 13 Sales 250 125 350 400 Qty 2 5 11 6 Can anyone help me, please. I have spend the last two days trying to get it right! Cheers. I have done this before using multiple subforms across the form. It requires opening a recordset to place primary key values into hidden text boxes on the form. These text boxes are used as the link master property of the subform controls.  SignatureDuane Hookom MS Access MVP -- > Hi > I have a query (which I have also done as a 'make-table' - if that makes [quoted text clipped - 6 lines] > it right! > Cheers. Thanks Duane. The strange thing is that I've set up a multi-column report that is fine - and looks as I want - but when I embed it as a sub-report into another report, it loses its formatting and becomes a single column down the left-hand side. Do you know why this is? Would it be easier to do this as a form, rather than a report? Thanks for your help Andy. >I have done this before using multiple subforms across the form. It >requires opening a recordset to place primary key values into hidden text [quoted text clipped - 11 lines] >> it right! >> Cheers. > Thanks Duane. > The strange thing is that I've set up a multi-column report that is [quoted text clipped - 4 lines] > Thanks for your help > Andy. Subreports have no concept of "pages". Pages are the responsibility of the parent report. A multi-column report that is set up as "Down, Then Across" will start a new column at the bottom of the *page* and a subreport has no idea where that is so you get one long column. Basically multi-column subreports only work when set up as "Across, Then Down" or when the subreport control has CanGrow set to false. Then the bottom of the control will take the place of the bottom of the page. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Great explanation Rick. SignatureDuane Hookom MS Access MVP -- >> Thanks Duane. >> The strange thing is that I've set up a multi-column report that is [quoted text clipped - 13 lines] > Down" or when the subreport control has CanGrow set to false. Then the > bottom of the control will take the place of the bottom of the page. |
Reply to this Message |
 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.