Format part of a concatenated control

  • Thread starter Thread starter cynteeuh
  • Start date Start date
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!
 
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.
 
Back
Top