Hi,

I am using a stored procedure as the source for a report in an Access
Project.  This report displays letters (which are generated by the
database into a single TEXT field for each person, similar to a
mail-merge feature).  The problem is that while CHAR(13) works as a
carriage return in SQL Server, it does not in Access (that uses
CHR(10)/(13)).

The code to generate the data in the stored procedure looks like this:

...
first + ' ' + last
+ CHAR(13) + address1
+ CHAR(13) + address2
...

and the physical data like this:

...
Joe Test
1000 Sample Drive
Suite 1100 A
...

However, when I view the report in the ADP, I have little rectangles
representing the CHAR(13) values, and all my text is run together.  If
I try to use CHR(13)/(10) in my code, I get an "'CHR' is not a
recognized function name." error.  If I put the CHR(10/13) in single
quotes it (obviously) treats it as standard text.

Any help with this problems would be greatly appreciated.

Thank you VERY much,
Birgit