Can you conditionally vertically center merge a report cell that is grouped?

[sdmecsmllc]

I've created a report in Access that produces company name and email addresses, with blank company name when multiple emails are present. I can't figure out how I can merge and center the cells in the company name column. Is it possible? With a report or a spreadsheet output?

Acme Inc	email1@email.com
Vinny's company	emailxyz@email.com
	email999@email.com
Great Big Mega company	emailxxx@email.com
	info@gmail.com
	support@hotmail.com

I want it to look like this:

Can this be done with conditional formatting in access or Excel?

[Gicu]

Here is some info for doing it in Excel:https://www.mrexcel.com/board/thread...nwards.942431/

For Access you should move the company name to the group headerand leave the emails in the detail section.

Cheers,

[Micron]

Access doesn't have "cells" per se; not in tables, forms, reports or queries. I think the best you can do in Access in a report is to use grouping as Gicu alluded to.

[CJ_London]

the horizontal centring is simple enough - just set the customer control property to centre text. For vertical centring you could try the following

1. create a separate report for emails
2. drag this into the detail section as a subreport and ensure cangrow/shrink is set and linkchild/master properties are set
3. in the detail on format event use code to adjust the top value for the customer control - something like

customercontrolname.top=(subreportname.height-customercontrolname.height)/2

I don't have time to experiment, but it may be the subreport has not resized when the format event runs in which case you could try getting the recordcount for the subreport and multiplying that the subreport detail section height - somehting like

customercontrolname.top=((subreportname.report.sec tion(acDetail).height*dcount("*","nameofEmailTable ","CustomerFK=" & customerPK))-customercontrolname.height)/2

[CJ_London]

had a play around with my suggestion and came up with this (excuse the data, just used something that came to hand) which works in print preview


It follows my second suggestion since the 'grow' event occurs after the format event

customercontrolname.top=((subreportname.report.section(acDetail).height*dcount("*","nameofEmailTable","CustomerFK=" & customerPK))-customercontrolname.height)/2

the trick is you need to size the subreport tall enough that when customercontrolname's top is assigned, it will still be above the bottom of the subreport otherwise the grow event will move the control down further