Posted on 2005-05-12
Last Modified: 2008-02-20

    I have a field on a form where I want everything to be uppercase...

I tried , > , but that only makes eveything uppercase after updated....

I would like all text to be uppercase while typing
Question by:jfilmore33
    LVL 65

    Expert Comment

    by:Jim Horn
    LVL 39

    Expert Comment

    You would have to use the _Change event for each control.

    I would let them type how ever and fix it with the AfterUpdate of the controls to make things easier.

    Private Sub myText_AfterUpdate()
        Me.myText.Value = UCase(Me.myText.Value)
    End Sub

    LVL 50

    Expert Comment

    by:Steve Bink
    >>> I would like all text to be uppercase while typing

    Tell the user to turn on their caps lock.  :)

    You have the option of using code to programmatically set the caps lock for them, but I generally do not suggest going this route.  There are weird issues with manipulating the status of keyboard toggle keys.

    Author Comment


    Where do I put,    UCase(YourFieldName) ????
    LVL 18

    Accepted Solution

    If you put the
    >  in the input mask for the control it will make it all upper case no matter what the caps lock setting is.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now