Format part of a concatenated control

C

cynteeuh

I'm a novice w/Access and not familiar w/VB code. Is there a simple way to
format only a part of a concatenated field on a report?

I have a name field that's concatenated w/first and last, but I'd like to
bold & capitalize the first name only. Is this possible w/a concatenated
field? I've concatenated in the underlying query of the report. OR is there
another option to achieve my goal?

Thanks in advance!
 
K

KARL DEWEY

A work around you might try is to not concatenate in the query. In the
report set Font Weight for first name to bold and text Align to right.
Position next to last name and set the height of both the same.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rich Text Format 0
Format one field in a string to bold 1
concatenated field in a report is not sorted 1
Bold Format Only Part of a Text Box Control 2
Different formats in a concatenated field 2
conditonal formatting 3
Using Multi-Select List Box Items in another Control 3
Format Combined Fields 3

Top