Report on multiple items with multiple-lines/item....I clueless

[bobleonard]

Hi,

Hopefully, someone can point me to some info/posts where I can write multiple lines for each record in a table. I would appreciate it.

The report would have 6 lines per item. I'm guessing 4-items per
page. Since the multiple item format only allows one item per line, I can't (?) use it.

Any suggestions or references would be helpful.
Thanks
BLenard

 

[Andrzejek]

Let say you have 3 records in the table.

Do you want to have something like this?
[tt]
RecID SomeField
------------------------
123 This is one line
of text here
234 Another record with
some text here
and more info here
345 Some text here
and more info here
with some stuff here
the end
[/tt]

Have fun.

---- Andy

 

[bobleonard]

Almost exactly so.

I've been thinking about looking at a Word merge???? It's been a long time since I've done one, but it seems to me, what I did was very close??

BL

 

[Andrzejek]

"Almost exactly so."

Could you by-pass 'Almost' and show here what 'exactly' you have in mind?

Have fun.

---- Andy

 

[bobleonard]

More like:

RecID SomeFieldA SomeOtherfieldB
ThirdField 4thField
--------------------------------------------------------
123 FieldAinfo FieldBdata
Field3info Field4

234 FieldAinfo FieldBdata
Fiels3info Field4data

345 FieldAinfo FieldBdata
Fiel33info Field4data

 

[dhookom]

Seems like I recently answered a similar question on Access Monster.

I need to show as many records per page as possible but I can't use the Tabular layout because I have too many fields even in Landscape Orientation. I created a report using Justified Layout but it only prints one record per page. Is there any way I can change this? I'm using Access 2007

You start your report design from "scratch" and add controls anywhere you want them in the detail section. These can be in rows and columns or however.

You don't have to be confined to a single horizontal row of controls.

Duane
Hook'D on Access
MS Access MVP