Others

Type German Umlauts and ß in Microsoft Access 2016

Algirdas JasaitisAlgirdas Jasaitis Nov 22, 2026 868 views

Question details

Enter German umlauts and ß in Access 2016 on an English-language computer.

Type German Umlauts and ß in Microsoft Access 2016
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.
Before you start

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.

Solution 1Recommended

Add and use a German keyboard layout in Windows

Use a German layout when you need to enter German characters regularly in Access.

1
Open language settings

Open Windows Settings and go to Time & language, then select Language or Language & region, depending on your Windows version.

2
Add a German keyboard

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.

3
Switch keyboard layouts

Press Windows+Space and select the German keyboard layout. Windows changes the keyboard mapping without requiring you to change the Access interface language.

4
Enter the characters

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.

Add and use a German keyboard layout in Windows
Switch back when finished: Press Windows+Space again to select your usual keyboard layout.
Free Microsoft Office alternative

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.

Enter German characters in spreadsheet cells using Windows input toolsOpen and save Microsoft Excel XLSX filesWork in a familiar, easy-to-use spreadsheet interfaceUse a free, lightweight office suite for everyday documents
microsoft office alternative - wps office

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.