Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009

    Unanswered: Stop case from changing

    I have created a DB to log all user records within our company. It needs to store usernames and passwords so needs to store irregular case but because its set to a text field it changes. For example ASmith turns to Asmith. How do I remove this property so it will accept what is typed?

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    This has to be set on each machine running the database.

    From the menu goto
    1. Tools
    2. Options
    3. Spelling
    4. Click on AutoCorrect Options Button
    5. Untick "Correct Two INitial CApitals"
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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