Results 1 to 5 of 5

Thread: Proper Case

  1. #1
    Join Date
    Mar 2009
    Posts
    120

    Unanswered: Proper Case

    Morning All -

    I tried finding this on the forum but couldn't find anything that seemed to work for me. I currently have Text field in my DB that is converting to UCase

    Private Sub Description_LostFocus()
    Me.Description.Value = UCase(Me.Description.Value)
    End Sub

    We are in teh process of converting our Billing System and everything is going to Proper Case. I tried using PCase and Proper in the above on the Lost Focus Property but it errors out. I amnot sure what I am missing as I am not good with the VB stuff. Most of what I know I've gotten from here it's all rather simple stuff.

    Any help would be appreciated as to what I am doing incorrectly. using Access 2007.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    consider using the strconv function
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    StrConv(Me.Description,vbPropercase)
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Mar 2009
    Posts
    120
    Thank you!! That worked Great!

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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