asked on

Text Box Format in 2010 Access Report

I know this is probably very simple, but I just cannot find the answer and would appreciate the assist.

For formatting reasons, my report uses a number of Text Boxes with the Control Source similar to this:

="Geographic Description:
" & "" & [Geo Description]

I would like the portion in quotes "Geographic Description:" in this case to be bold and perhaps a larger font, but cannot figure out a way to split the field for formatting.

Appreciate any help. Thanks!

SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PhxDB

ASKER

I had labels for each field, but combined them because the formatting wasnt lining up. I used "Can Grow" for the Text Box since it could be up to several paragraphs long ... but then couldnt keep the label lined up correctly.

On the report, the label would be lined up at the top but smaller (height-wise) as it was still the same size as in Design View despite the Text box growing. This would actually be acceptable for the report ... but then when I go to Print Preview (and subsequently Print), the labels no longer line up with the Text Box.

Any thoughts on this? Thanks.

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PhxDB

ASKER

Great Idea - Thanks!