Subreport Formatting (1 Viewer)

[JessLeaEss]

Hello!

I hope this makes sense, sorry in advance.

I have multiple companies and want to format the subreport using the main report theme.

For example:

Company 1 uses "Office" theme.
Company 2 uses "Facet"
Company 3 uses "Integral"
etc...

I have a different main report for each company with the company name and logo and a bit more data that is company specific.

The bulk of the data pulled uses the same subreports and queries, though. I really don't want to have to create a new subreport for every company... please tell me there is an easier way?

(I know I *could* use a generic theme across all companies, but... that's generic.)

 

[June7]

Could probably use VBA code to set colors and fonts.

I've never used "Themes" settings. A quick Google search "Access VBA Themes" indicates they might be managed with VBA. No idea if they can be applied selectively to reports.

 

[JessLeaEss]

Could probably use VBA code to set colors and fonts.

I've never used "Themes" settings. A quick Google search "Access VBA Themes" indicates they might be managed with VBA. No idea if they can be applied selectively to reports.

Thank you for the thought! I think I may have stumped the community, I've had a lot of looks but no answers. Just something to put on the wishlist for Access, I think...