Type German Umlauts and ß in Microsoft Access 2016
Question details
Enter German umlauts and ß in Access 2016 on an English-language computer.

- Product
- Microsoft Access 2016
- Device & OS
- Windows; version not provided
- Scenario
- The user is entering German text in an Access table or form.
- Observed behavior
- The Ctrl+Shift+semicolon shortcut inserts the current time in Access instead of preparing an umlaut.
Open the Access table or form and select an editable text field. If you plan to change keyboard layouts, check which Windows display language and keyboard settings are currently in use.
Add and use a German keyboard layout in Windows
Use a German layout when you need to enter German characters regularly in Access.
Open Windows Settings and go to Time & language, then select Language or Language & region, depending on your Windows version.
Open the language options for an installed language and choose Add a keyboard, then select German. If it is not available, add German as a language first.
Press Windows+Space and select the German keyboard layout. Windows changes the keyboard mapping without requiring you to change the Access interface language.
Click the Access text field and type ä, ö, ü, or ß using the German layout. If the physical key labels do not match, search Windows for On-Screen Keyboard to see the active layout.

Copy German characters from Windows Character Map
Use Character Map for occasional characters without changing your keyboard layout.
Enter German text in WPS Spreadsheets
For tabular data that does not require an Access database, WPS Office is a free, lightweight alternative with a familiar interface. Open compatible Excel files and enter German characters using your Windows keyboard layout or Character Map for an easy transition.

Frequently Asked Questions
Why does Ctrl+Shift+semicolon insert the time in Access?
Access uses Ctrl+Shift+semicolon as a shortcut for inserting the current time. Use a German keyboard layout or paste characters from Windows Character Map instead.
Can I type German characters without changing my keyboard layout?
Yes. Open Character Map from the Windows Start menu, select and copy the character, then paste it into the Access field with Ctrl+V.
How do I switch back to my English keyboard?
Press Windows+Space and select your usual English keyboard layout from the list.
Where are the German characters on an English physical keyboard?
After selecting the German layout with Windows+Space, open On-Screen Keyboard from the Windows Start menu to see the active key mapping.
Can WPS Spreadsheets replace an Access database?
WPS Spreadsheets can handle tabular data in formats such as XLSX, but it does not replace Access database features. Keep using Access if you need its forms, queries, or relational database functions.




