I am running a sort of plan on a page which covers several elements, Defects, Config Chane Requests
etc. which will have an associated query with each section that will underly sub forms on the
master form/report

The data will be filtered and return a sequential list of numbers as in:

12435
34654
34567
32456
87654

This will be similar for all subforms/reports

Is there a way through code to make the data display in text boxes or similar as:



12435 34654 34567 etc
34567 32456 87654 etc


This will save space and allow more data to be fitted on one page..

Thanks.. J


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

divventknaa wrote:

In a report you can use multicolumn reports. In the PageSetup button of
a report you can multicolumn across and down or down and across.

But this might not be what you mean.

The word DOHHH! springs to mind.... the multicolumn on page setting will do the job perfectly.
Been playing with access for years and never even noticed the columns tab in the Page Setup menu...
LOL

Thanks


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

divventknaa wrote:

across. For some reason it burps on across then down.

In a report query I might add a column like GroupIt.
GroupIt : 1.

Now every record has GroupIt of 1. Then I create a group on GroupIt via
sorting/grouping. Then I add put the headers in the GroupIt band. Then
set the RepeatSection for that group band to true. Now the headers flow
across per column.

Why it works for down/across and not across/down is beyond me.

Salad wrote:

You don't need a field in the query to do that. Just set
the Sorting and Grouping expression to a constant expression
such as =1 or ="Headers"

--
Marsh

Marshall Barton wrote:

Cool. I never noticed the word "Expression" in the Sorting/Grouping dialog.

Any idea on why Down/Across works but fails on Across/Down?

Salad wrote:

RepeatSection is invoked for new pages and Down then Across
columns, but to my way of thinking, it doesn't make sense
for RepeatSection to do to do anything for each new row in
Across then Down. It's kind of like each new column is a
pseudo group but each row is just more details. Not exactly
an explation and I guess the designer could have worked out
something for Across then Down, but they didn't, maybe only
because to was more complicated???

--
Marsh

Marshall Barton wrote:

It does seem odd. If I specified 3 columns, then I'd expect 3 columns
of headers if 3 columns are filled in. It creates a header when
down/across when a new column is filled in so the routine has been
built. Since a column it's being filled in across/down, it's probably a
bug. I think most users, at least me, go down/across anyway (although
it's the second option in Page Setup) so it was probably forgotten
and/or a low priority for the Access development team.

Salad wrote:


I don't know, but Down then Across can just repeat the
header on a column transition. But Across then down does a
column transition on every detail so, in my mind, it's more
complex to figure out when and where the repeated header
should be applied.

--
Marsh