Underline part of a contatenated statement

[Mark G]

Does anyone know if it is possible to underline only part of a contatenated
statement? I would like to be able to have a contatenated statement for a
report that would produce Author(underlined), Publisher, Edition, Chapter. I
only need the author underlined but I end up with all or nothing. I am
running Access 2007. Any help would be great.

Thanks
Mark

 

[Allen Browne]

Yes: you can do that in Access 2007 (but not previous versions.)

This example underlines the surname:
=[FirstName] & " <u>" & [Surname] & "</u>"

Be sure to set the Text Format property of the text box to:
Rich Text

(Although MS calls it rich text, the tags are actually HTML.)

 

[Mark G]

Thank you Allen for the quick response. It works perfectly

Mark

Yes: you can do that in Access 2007 (but not previous versions.)

This example underlines the surname:
=[FirstName] & " <u>" & [Surname] & "</u>"

Be sure to set the Text Format property of the text box to:
Rich Text

(Although MS calls it rich text, the tags are actually HTML.)

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

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

Does anyone know if it is possible to underline only part of a
contatenated
statement? I would like to be able to have a contatenated statement for a
report that would produce Author(underlined), Publisher, Edition, Chapter.
I
only need the author underlined but I end up with all or nothing. I am
running Access 2007. Any help would be great.

Thanks
Mark