Trim statement in reports

G

Guest

Hi Everyone,

I'm using a Trim statement in a report which includes a field name and some
text, such as... Trim([Name] & " you have won the following:").

My question is, is there any way to code the trim statement so that only
part of it is in a bold font and the rest in a regular font. Say, [Name] in
bold and the text regular.

Thanks for your help.

Kevin D.
 
A

Al Camp

Kevin,
Try 2 fields instead of one. Right justify the BOLD Name, and Left Justify the NORMAL
text.
Butt them up against each other...
The | will represent the edge of the respective field borders...

| Bob Smith| you have won the following... |

This may not work well "within" a sentence, but should be fine as a standalone...

blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah
| Bob Smith| you have won the following... |
blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah
 
G

Guest

Al,

Thanks for the suggestion, but I was hoping to keep everything left
justified as I do not know how long the [Name] field will be before the text.
It's a good work around though and maybe I can incorporate it.

Thanks again.

Kevin D.

Al Camp said:
Kevin,
Try 2 fields instead of one. Right justify the BOLD Name, and Left Justify the NORMAL
text.
Butt them up against each other...
The | will represent the edge of the respective field borders...

| Bob Smith| you have won the following... |

This may not work well "within" a sentence, but should be fine as a standalone...

blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah
| Bob Smith| you have won the following... |
blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


Kevin D. said:
Hi Everyone,

I'm using a Trim statement in a report which includes a field name and some
text, such as... Trim([Name] & " you have won the following:").

My question is, is there any way to code the trim statement so that only
part of it is in a bold font and the rest in a regular font. Say, [Name] in
bold and the text regular.

Thanks for your help.

Kevin D.
 

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

Top