conditonal formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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).
 
Thanks for the quick response. I didn't think it could be done. My company
hasn't upgraded to Access 2007 yet.

Ken Snell (MVP) said:
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>


bikemrh said:
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.
Click to expand...
Click to expand...
 
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.
Click to expand...

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
 
Back
Top