Stop objects moving when others grow

[XelaIrodavlas]

Hi all,

I was wondering if there's a way to set objects so that they don't get pushed down if an object above is set as Yes in the CanGrow property? Alternatively, can a report be split into columns?

I know this would usually be a stupid idea, but I have been asked to replicate a form (previously written up on Word) which has two columns of information. As luck would have it all the fixed fields are on the Left hand side, so that part doesn't need (or want) to grow, However, the Right hand side has several sub-reports which can display 1-5 records each.

So if any of the sub reports show more than 1 record, they push down everything below it, but this includes the Left hand objects, creating gaps and often pushing the report onto 2 pages.

I am stumped,

Any ideas?

Thanks all

 

[CJ_London]

this link may help

http://office.microsoft.com/en-gb/access-help/multiple-column-reports-HA001156534.aspx

Also, don't know if it will work, but you could try putting data on the left side in a subreort

 

[vbaInet]

It would be nice to see a screenshot of the word document and one of your report in design view.

 

[XelaIrodavlas]

Thanks I just put the items from the left into a sub form, it's a bit of a faff but perfectly functional. I Just needed a common sense way of looking at it

Cheers,