Results 1 to 3 of 3
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    uppercase?


    Hello All, Using 2003; I have a database that imports data from a spreadsheet. When I look at the data in the table; its in all caps. but when I view it in a form for editing or report, some of the data is in lowercase. I need it to be upper case like in the table. I tried the Keypress code but it only changes new data not existing. Why does it change case in the forms and on the report and how can I force it to uppercase.
    thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    The table must have format setting for display in all caps. Format setting does not actually change the data. Review this article about format property http://office.microsoft.com/en-us/ac...010334645.aspx

    Check the Format property of field in table. Does it show a > character? This forces all text to be uppercase. You can use this same character in Format property of controls on form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    Got it. Thanks so much!

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

Similar Threads

  1. Query for Partial Uppercase Text in Field
    By pjordan@drcog.org in forum Queries
    Replies: 15
    Last Post: 12-29-2011, 12:53 PM
  2. Replies: 1
    Last Post: 03-01-2011, 03:01 PM
  3. Changing table names from lowercase to uppercase
    By supernix in forum Database Design
    Replies: 1
    Last Post: 09-03-2010, 10:08 PM
  4. Uppercase to Lowercase
    By tigers in forum Reports
    Replies: 1
    Last Post: 09-28-2009, 10:48 AM

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