How to fix dates or garbled text when printing

Separate source-data and date-format problems from font, encoding and driver problems before changing the template.

What this page helps you do

Separate source-data and date-format problems from font, encoding and driver problems before changing the template.

Checks and steps

1. Compare one incorrect source value with the exact expected print result.
2. Check whether the BarTender data source is a date, time or plain-text value.
3. Apply one explicit display format, such as yyyy-MM-dd, and verify month/day order.
4. If Chinese characters become boxes or question marks, use a font available on both the computer and print path.
5. If Excel dates appear as numbers, standardize the Excel column format and refresh the connection.
6. Print only the known failing record before returning to batch printing.

Scope and verification