Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm working with letters and envelopes. In some instances, I need to convert to all caps, which I've done with
    (UCase([Title_UpperCase]). I have a couple of other fields that are currently all caps but need to be updated so the first letter is capitalized and all other letters are lower case. Can someone please tell me how to do that?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use the StrConv function for this, with 3 = vbProperCase as second argument:

    StrConv([FieldName],3)

Posting Permissions

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