• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1140
  • Last Modified:

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
0
Louverril
Asked:
Louverril
1 Solution
 
LouverrilAuthor Commented:
Can't believe I have just managed to fix this.

I altered the height of the two second row fields to 0.05cm instead of 0mm and they now line up - see attached.

Lou
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now