Does anyone have any suggestions for how I can overcome this problem on a report?
It’s set up in tabular form. One column has a lot of data (memo field), causing the report to need many pages (80). Four other fields have very little data, but take up space across the page. I’d like to arrange it so that I have 2 fields together, one on top of the other (twice). Then field 3 can be a lot wider.
Field 1 Field 3 Field 4
Field 2 " Field 5
"
"
But when I put them in this position 1 and 4 sit at the top of the row and 2 and 5 sit below 3, causing me to need even more pages.
Field 1 Field 3 Field 4
“
“
“
Field 2 Field 5
I could concatenate fields 1 & 2 and 4 & 5 , but I’d have an expression that told the second field to start on a new line. Is that possible?
By the way, fields 1 and 3 are already concatenated from 2 fields each.
I'm using Access from Office 14 - it's not in the list for registering.
Many thanks in advance,
Robyn