Results 1 to 9 of 9
  1. #1
    dylcon is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Ann Arbor
    Posts
    130

    How to have all text in a textbox be uppercase

    Hello, I have some text boxes that are used for entering new records where I want the text to be uppercase regardless of what the user is typing.
    I have read that you simply insert '>' character into the input mask property, but it is not working. Anyone have any ideas? Thanks!

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Put > in the format.
    Dale

  3. #3
    dylcon is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Ann Arbor
    Posts
    130
    That does not seem to be working. I have tried this before. I have also done this to the field it is bound to and it still does not work. Any ideas why?

  4. #4
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    I have tried this before. I have also done this to the field it is bound to and it still does not work.
    This is confusing.

    You should be putting the > into the format of the text box you want to have as Upper Case.
    OR if it is in a table you can put in in the table format for that field.

    Dale

  5. #5
    dylcon is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Ann Arbor
    Posts
    130
    Once again, I have inserted that into the format on both the bound field and on the actual form and it is not working still. Just to confirm, it is the Format portion on the Property Sheet, correct?

  6. #6
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Yes.
    Works for me.

    Dale

  7. #7
    dylcon is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Ann Arbor
    Posts
    130
    Hmmm well alrighty then

  8. #8
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    You do understand, don't you, that this is not going to convert to Upper Case until after you exit the Control?

    Have you tried this on multiple Fields/Controls, or have you just experimented on one of them, to date?

    Linq ;0)>

  9. #9
    dylcon is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Ann Arbor
    Posts
    130
    Thanks Linq.

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

Similar Threads

  1. Replies: 7
    Last Post: 02-21-2012, 05:48 PM
  2. uppercase?
    By slimjen in forum Forms
    Replies: 2
    Last Post: 01-31-2012, 03:30 PM
  3. Query for Partial Uppercase Text in Field
    By pjordan@drcog.org in forum Queries
    Replies: 15
    Last Post: 12-29-2011, 12:53 PM
  4. Replies: 3
    Last Post: 08-18-2011, 07:31 AM
  5. Replies: 1
    Last Post: 03-01-2011, 03:01 PM

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