Garbled text in Access 2013 Print Preview

Question

having a problem with an Access 2013 program that I need some outside insight on.

We have upgraded our terminal server to windows server 2012 r2 from windows server 2008 r2, along with Office 2010 ProPlus 32-bit to Office 2013 ProPlus 32-bit.

We have a few access programs that access our iSeries DB2 database, via odbc. All of them seem to be working well after the upgrade, bar one.

The specific program takes an input for work order and then produces a report to be printed. The output is a mixture of greek and english characters. When viewing in report view, text is fine, when you switch to print preview, text becomes garbled. See screenshots line starting with "batch number" below. Also this report contains a sub-report. Not sure if this is relevant.

Report View:

Print Preview:

Current language is set to Greek for non-unicode programs, and odbc settings mirror those of the previous server (language id and conversion of binary data).

I have also tried changing the font from tahoma to arial.

I have tried using different pdf printers and physical printers to see if it renders differently.

I have tried strConv([variable],0,[lcid]) and strConv([variable],64,[lcid]) with various possible LCIDs at the query level. Though I'm not sure I've exhausted this yet.

Looking at the data views in the underlying tables from the source DB, data is displayed correctly, also in the queries.

Not sure what is going wrong here, any ideas?

Answer 1

Since your data seems to be fine in the tables and queries, I would suggest:

Copying all controls from design view of the report and paste them into a design view of a NEW report to see if it duplicates the problem.

If it does duplicate the problem then I would start designing the same report from scratch, starting with the problematic controls.