Bold part of field... in Access 2007

[SF]

Hi,

I have a reports consist of some unbount fields that combined text and field
togather such as ="I want to cancel my reservation # "& [Reservation ID]& "
dated "& [ResvDate]

Is there a way to bold only the [Reservation ID] with Access 2007?

SF

 

[Allen Browne]

Yes. Open the report in design view.
Right-click, the text box, and choose Properties.
Set the Text Format property to: Rich Text.

Now set the ControlSource to:
="I want to cancel my reservation # <b>"& [Reservation ID]& " </b> &gt;
dated " & [ResvDate]

A2007 uses the HTML codes for bolding.
I assume it will handle the greater than character okay.

This functionality is quite useful. I recently put together an example
showing how to highlight where the search text was found in a field, using a
similar approach:
http://allenbrowne.com/AppSearchHighlight.html

 

[SF]

Thank you very much for your prompt response.

SF

Yes. Open the report in design view.
Right-click, the text box, and choose Properties.
Set the Text Format property to: Rich Text.

Now set the ControlSource to:
="I want to cancel my reservation # <b>"& [Reservation ID]& " </b> &gt;
dated " & [ResvDate]

A2007 uses the HTML codes for bolding.
I assume it will handle the greater than character okay.

This functionality is quite useful. I recently put together an example
showing how to highlight where the search text was found in a field, using
a similar approach:
http://allenbrowne.com/AppSearchHighlight.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi,

I have a reports consist of some unbount fields that combined text and
field togather such as ="I want to cancel my reservation # "&
[Reservation ID]& " dated "& [ResvDate]

Is there a way to bold only the [Reservation ID] with Access 2007?