conditonal formatting

[Guest]

I have a concatenated string where I only want part of it to be bold. Here is
the string:
=[Road Name] & " " & [Condition] & " " & [Description] & " due to " & [Due to]

I am trying to get [Road Name] to be bold and haven't been able to
accomplish this. Each field is from a table. Road Name and Description are
fields a user needs to enter on a form. The other two are from a list box
that the user selects.

Please help.

 

[Ken Snell \(MVP\)]

This cannot be done unless you're using ACCESS 2007's rich text control, or
unless you're using a third-part rich-text control (e.g., see Stephen
Lebans' website www.lebans.com).

 

[Guest]

Thanks for the quick response. I didn't think it could be done. My company
hasn't upgraded to Access 2007 yet.

This cannot be done unless you're using ACCESS 2007's rich text control, or
unless you're using a third-part rich-text control (e.g., see Stephen
Lebans' website www.lebans.com).

--

Ken Snell
<MS ACCESS MVP>

I have a concatenated string where I only want part of it to be bold. Here
is
the string:
=[Road Name] & " " & [Condition] & " " & [Description] & " due to " & [Due
to]

I am trying to get [Road Name] to be bold and haven't been able to
accomplish this. Each field is from a table. Road Name and Description are
fields a user needs to enter on a form. The other two are from a list box
that the user selects.

Please help.

 

[fredg]

I have a concatenated string where I only want part of it to be bold. Here is
the string:
=[Road Name] & " " & [Condition] & " " & [Description] & " due to " & [Due to]

I am trying to get [Road Name] to be bold and haven't been able to
accomplish this. Each field is from a table. Road Name and Description are
fields a user needs to enter on a form. The other two are from a list box
that the user selects.

Please help.

Not doable within Access as shipped. You either need a RichTextFormat
control or ......
Check out the Lady.ZIP report at
http://www.lebans.com/mixbold-plain.htm