How to Fix Microsoft Access Filter Showing Dots Instead of Text
Question details
The user is experiencing a display issue where filtered field values in Microsoft Access appear as three dots (...) instead of the actual text.

- Product
- Microsoft Access
- Device & OS
- Windows
- Scenario
- Viewing or filtering data in an Access database where specific field values are being visually truncated.
- Observed behavior
- The filtered data values are truncated and displayed as three dots instead of expected text, an issue occurring randomly on specific computers depending on their local display configurations.
Ensure you have administrative privileges on your Windows computer to adjust display settings, and confirm that your Microsoft Access application is fully updated.
Adjust Windows Display Scaling
High display scaling settings in Windows can cause text truncation in Microsoft Access, reducing it to a lower percentage often restores the text visibility.
Windows display scaling helps enlarge UI elements on high-resolution screens. However, setting this scaling too high (such as 250%) can cause older or unoptimized applications like Access to miscalculate field widths, resulting in text being replaced by three dots.
Right-click on any empty area of your Windows desktop and select 'Display settings' from the context menu.
In the Display settings window, scroll down until you find the 'Scale and layout' section.
Click the dropdown menu under 'Change the size of text, apps, and other items' and reduce the scaling percentage from your current setting (e.g., 250%) to 125% or 100%.
Close Microsoft Access if it is open, relaunch your database, and check if the filtered fields now display the full text instead of dots.

Change Field Font and Default Printer Settings
Local environment variables like incompatible fonts or default printer metric glitches can also cause display rendering errors in Access.
Try WPS Office for a Seamless and Error-Free Office Experience
While Microsoft Access is a traditional database tool, many data management, filtering, and reporting tasks can be easily handled without display scaling issues using WPS Spreadsheet. WPS Office provides a free, lightweight, and highly compatible suite for all your document needs.
- 1. Download WPS Office: Visit the official WPS website to download the free WPS Office installer.
- 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up the software.
- 3. Manage Data in Spreadsheet: Open WPS Spreadsheet to import your data, filter records, and create reports effortlessly.

Frequently Asked Questions
Why does Microsoft Access show dots instead of text?
This display issue generally happens when the column width is too narrow, or when Windows display scaling is set too high (e.g., 250%). High scaling causes the UI to miscalculate spatial boundaries, forcing it to truncate the text and display ellipses (...) instead.
Does changing the font fix the display dots in MS Access?
In some cases, yes. Changing the field font to a standard TrueType font like Arial or Times New Roman can resolve rendering glitches that are triggered by specific character combinations, such as acronyms containing dashes.
Can a printer driver cause text display issues in Access?
Yes. Microsoft Access relies on the default printer's metrics to render text accurately on the screen. Changing the default printer to 'Microsoft Print to PDF' or updating your current printer driver can often refresh the metrics and fix text truncation issues.




