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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.