Results 1 to 3 of 3
  1. #1
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    146
    Thanked 156 Times in 149 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,436
    Thanks
    1
    Thanked 34 Times in 34 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
    1,725
    Thanks
    146
    Thanked 156 Times in 149 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
  •