Others

How to Fix Microsoft Access Filter Showing Dots Instead of Text

Rana GarciaRana Garcia Nov 2, 2026 870 views

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.

How to Fix Microsoft Access Filter Showing Dots Instead of 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.
Before you start

Ensure you have administrative privileges on your Windows computer to adjust display settings, and confirm that your Microsoft Access application is fully updated.

Solution 1Recommended

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.

1
Open Display Settings

Right-click on any empty area of your Windows desktop and select 'Display settings' from the context menu.

2
Locate Scale and Layout

In the Display settings window, scroll down until you find the 'Scale and layout' section.

3
Adjust Scaling Percentage

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%.

4
Restart Microsoft Access

Close Microsoft Access if it is open, relaunch your database, and check if the filtered fields now display the full text instead of dots.

Adjust Windows Display Scaling
Optimal Scaling: Try to find a middle-ground scaling percentage (like 125% or 150%) that resolves the Access display issue while still being comfortable for your eyesight.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download the free WPS Office installer.
  2. 2. Install the Software: Run the installer and follow the quick on-screen instructions to set up the software.
  3. 3. Manage Data in Spreadsheet: Open WPS Spreadsheet to import your data, filter records, and create reports effortlessly.
Highly compatible with Microsoft Office formats, including Excel, Word, and PowerPoint.No text truncation or UI scaling glitches when viewing and filtering large datasets.Lightweight installation with fast startup times and low system resource usage.Familiar and intuitive user interface allowing for a seamless transition.
microsoft office alternative - wps office

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.