Link to home
Start Free TrialLog in
Avatar of Louverril
Louverril

asked on

Access report layout - how can I removee the gaps between these two rows?

Please see the attached 2010 database - one table and one report (A3 size).

I also attach a jpeg of the report.

The fields in the two rows of the detail section are set to grow and shrink in the properties - as data may or may not exist in the fields or it make be too long and need more than one line - in the main this works fine.

But I cannot get the report to print out completely correctly.

In the detail section there is a row of fields - these print fine.
Underneath that row there is a second row which has only two fields in it txtIDESC_ExtDescription and txtITMG_Instructions.

If only one of these second row fields has contents the report is formatted fine - see the rows beginning 004 and 006.

However if both of these fields has contents then the fields print with a gap above them equal to the height of the rightmost field.

I have tried all sorts of things including adjusting the top positions and shrink yes/knows, adjusting plain test rich text, adding a gap below - all sorts.

It is driving me crazy. I have never had this problem before and create a lot of reports with shrink/grow fields.

Can anyone get the fields to print without the top gap?!!

Thanks,
Lou
ProblemReport.JPG
ProblemReport-Gaps.accdb
ASKER CERTIFIED SOLUTION
Avatar of Louverril
Louverril

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial