MS Access 2003 will not display new lines for a DB2 table column

[tbtcust]

Hello everyone.

I have a MS Access 2003 report that is displaying data from a DB2 database.
The MS Access database tables are linked to the DB2 database tables via odbc.
There is a column in the DB2 database that has a data type of varchar 255.
That DB2 column has new lines in it that was entered via a DB2 update SQL. See example below.
The MS Access report will not display the newlines. See example below.

Is there something special I need to have for the MS Acess report to display the new liens? Thanks in advance for any help.

DB2 table example:
New_Line_1
New_Line_2
New_Line_3

MS Access report display example:
New_Line_1 New_Line_2 New_Line_3

 

[kzutter]

My guess is that the DB2 UPDATE query used Linefeed characters (ascii code 10).
Access is expecting a Linefeed/Carriage Return pair. (ascii codes 10 & 13)

You may have to condition the field data by replacing the linefeeds.

This should work:

Replace(YourString,vbLf,vbCrLf)

Good Luck