Results 1 to 3 of 3
  1. #1
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    2,015
    Thanks
    164
    Thanked 192 Times in 185 Posts

    Problem with text field formatting

    I'm using Access 2003 and have a table with a text field. I want to make entries like AAa but when I enter this it promptly changes it to Aaa. Is there any way of making keep the capitalisation I want rather than it changing it?

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,466
    Thanks
    1
    Thanked 40 Times in 39 Posts
    Quote Originally Posted by access-mdb View Post
    I'm using Access 2003 and have a table with a text field. I want to make entries like AAa but when I enter this it promptly changes it to Aaa. Is there any way of making keep the capitalisation I want rather than it changing it?

    Thanks
    Several things control this. One is the "Allow AutoCorrect" property (set it to No). Also, check your Formatting and Input Mask to see if they are present and what are doing.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. The Following User Says Thank You to MarkLiquorman For This Useful Post:

    access-mdb (2012-09-04)

  4. #3
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    2,015
    Thanks
    164
    Thanked 192 Times in 185 Posts
    Yay, that's done it. Just unticked the 'Correct two initial capitals' box and it now works. Just have to ensure I don't enter two caps when I didn't mean to.

Posting Permissions

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