Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Re-Post - Unusual Formatting Problem

Status
Not open for further replies.

Robbo1974

Technical User
Jun 1, 2001
151
0
0
GB
Hi all,

Apologies for re-posting but this is driving me crazy!

I have a control in a report which pulls together a set of values from various fields thus:

Code:
Control Source = "Order Number " & [oldordernumber] & ", placed by " & [placedby] & " on " & [date] & " Type = " & [Type]

In order to display an order number, who placed it, when it was placed and what type of order it was.

I want to display the information from field [type] in bold, leaving the rest as normal.

Example:

Order Number is R555

It was placed by John Smith

It was placed on 13/04/02

The type of order is repeat

So I want the control to display like this:

Order Number R555, placed by John Smith on 13/04/02 Type = Repeat

Any ideas on how can I do it?

Thanks in advance, Iain
Robbo ;-)
 
I don't think you can do this. You would have to have a separate text box with its font weight set to bold. Have fun! :eek:)

Alex Middleton
 
I have the same problem/question. How do you bold and underline three words in a text box sentence in a report?
 
Dear Robbo1974
Why not use Conditional Formatting to highlight the entire text box?
and colour code it for the different significance?
HTH
Regards Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top