Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Formatting Merged Fields (2003)

    I have three fields in a table. FirstName; SecondName and LastName. In a query, I create a merged field called FullName: [FirstName] &" "&[SecondName]&" "&[LastName]
    When I display the FullName field on a form, I wish to show the LastName part only of the merged field in upper case. I have formated the LastName field in the Table to Upper Case (Using > in format field), but get Sentence case on my form for the whole field. I notice that the data has actually been entered (or more correctly imported from Excel) with all three fields having an initial capital letter, ie Sentence case)

    Any ideas on clever ways to force the third part of my merged field to all capitals? or as Bold Font perhaps? Would appreciate the reply.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting Merged Fields (2003)

    Try
    <code>
    FullName: [FirstName] & " " & [SecondName] & " " & UCase([LastName])
    </code>
    The UCase function converts its argument to upper case.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting Merged Fields (2003)

    Wonderful Hans. I barely had time to make a coffee after my post, before I saw your reply. Must be late in Netherlands, but once again thanks. As soon as I saw your answer, I hit myself in the head, It was bloody obvious (after someone pointed it out)

Posting Permissions

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