Results 1 to 4 of 4
  1. #1
    bbylls is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Dec 2009
    Posts
    33

    Capitalization

    Somewhere in this forum (I think) I saw something that will capitalize the first letter of the text box (i.e. putting in someones name)
    I can't seem to find it now.
    Can anyone point me to this or have any suggestions for this?


    In Paradox this was just a setting. Maybe in Access but can't find it.
    Thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Try:
    Me.YourControlName = StrConv(Me.YourControlName,vbProperCase)
    In the AfterUpdate event of the control.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    bbylls is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Dec 2009
    Posts
    33
    That worked great.
    Thanks so much.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Glad I could help. Thanks for posting back.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums