ms access - How to turn off proper-case correction on a specific field?

Question

I have an Access-based Employee table and have a field to hold username values. The username format for the application I'm tracking is FirstinitialLastname ("JDoe").

However, when I enter the username value in my Employee table, Access is automatically changing it to "Jdoe".

Is there a way for Access to accept what is being entered into this field and not change it? Searching online I see posts for how to turn on proper case, but for this particular field I don't want it to modify what I have entered.

In the near future, this Access database will be split in order to move the data out of Access and into SQL Server. Will the issue I'm having be alleviated once the data is stored in SQL Server?

Any guidance is greatly appreciated.

Thanks!

question from:https://stackoverflow.com/questions/65947849/how-to-turn-off-proper-case-correction-on-a-specific-field

Answer 1

You can stop Name AutoCorrect from Access Option. Microsoft article here in this link. Set name AutoCorrect options

When you type name like JDoe then after finishing typing, access automatically correct two capital letter and it show a small smart menu. From that you can also make changes to stop auto correct. See below screenshot.