Results 1 to 5 of 5
  1. 03-16-2011, 09:15 PM #1
    Fifa
    Fifa is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    14

    Capslock

    How to make autocapslock in microsoft access form??
    Reply With Quote Reply With Quote
  2. 03-17-2011, 11:10 AM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    If I understand your intent, you can use

    fldnameOnForm = UCASE(fldnameOnForm)

    UCASE(fld) results in the value in fld being Uppercase
    Reply With Quote Reply With Quote
  3. 03-21-2011, 07:25 AM #3
    Fifa
    Fifa is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    14
    Can you explain more about that..because i couldn't understand it.
    I am very beginner in microsoft access..

    thank you in advance..
    Reply With Quote Reply With Quote
  4. 03-21-2011, 08:13 AM #4
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Use the After Update event of each control you want in CAPS
    and set the value.

    Me.txtControl = UCase(Me.txtControl)


    Here's another link from M$oft
    http://support.microsoft.com/kb/209520
    Reply With Quote Reply With Quote
  5. 03-21-2011, 11:17 PM #5
    Fifa
    Fifa is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    14
    i already try..but still failed
    can u explain more..
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums