Vertical Center Text in Report Fields

[billgyrotech1]

Hello,

I could use your help please. First open the form AFRs. In the field AFR Number press Ctrl + F to search and put in the number 82449. This AFR has 30 parts that I would like displayed on a report. Next click on the 'Preview Parts Requisition' blue shape on the right.

The report only displays the first 15 parts and I would like the 16-30 parts displayed to the right with the Qty, Part Number, and PO #.

Also how to vertical center the text ?

I really appreciate the guidance or suggestions on how to do this.

[June7]

You want a multi-column report. This is setup in report PageSetup.

However, you have form not report as subreport.

So set [AFRsParts subreport] for multi-column design and use it as subreport, not form AFRsParts.

You have to put two sets of the labels in the report Header section. Placing the copied set to line up with the second column fields will involve a little trial and error.

Not sure what you mean by 'vertical center'.

[billgyrotech1]

Okay I tried that but it doesn't at all look like what I want.

I would like Qty /Part Number/Po# listing 15 rows of parts then the other 16 thru 30 parts on the 2nd half of the page.

Thanks for your help

[rpeare]

Your AFRsParts should be storing your PartNumber ID field not the text of the part number
you are *still* referencing a subform in your report instead of your subreport look at the SOURCE OBJECT of your subreport on the PARTS REQUISITION report, it's referencing the form AFRsParts *NOT* the AFRsParts Subreport

I have reworked this to force a 30 items subreport with 15 items in each column

AFR System 10.7.accdb.zip

[billgyrotech1]

That seems to work but it looks messed up with the extra table and report.

This whole process seems so confusing to me.

[billgyrotech1]

Oh the vertical center of text is referring to when I make the Height of the text larger the text seems to stay on the top part of the textbox and not vertically centered.

[June7]

Set subreport container CanGrow property to No. Size the container so 15 records list in first column.

Resize textbox. Or use TopMargin property.

[billgyrotech1]

How can the Qty, Part Number, and PO# be headings and the data listed in rows below them?

[billgyrotech1]

I moved the labels to the header part of the page and set the fields side by side and it works.

Thanks June