Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Unanswered: apply bold formatting to part of concatenated string


    I have a text box on a report that references three name fields (first, middle, last). The code looks like:

    =[LastName] & ", " & [FirstName] & [MiddleName]

    I want to apply bold formatting only on the LastName portion. Is there something similar to the Ucase function (ie =UCase([LastName]) & " "...) that can be used to apply bold formatting to the font?

    Any help would be greatly appreciated.


  2. #2
    Join Date
    Dec 2003


    I do believe this can only be done with a common dialog module add in for MS Access. With that you get an RTF formtter that will allow you to adjust the format of code independent of other items in the text box.

  3. #3
    Join Date
    Dec 2003

    Another Idea

    You could however create two text boxes. one for the first name, make that bold and right justified. Then create a second text box, normal and have that be fed the middle name and the first name

    ucase only changes the case of the letters to all uppercase, has nothing to do with the format, i.e. italicised, bold, underlined.

    ucase("cat") = "CAT"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts