Any help on this one much appreciated.
I have and ADP (XP) to SQL Server (2000). On one particular form I want to
display address information in a single control in the form:
12 The Road
To do this in a single control I need to concentrate information from the
five fields into one field in the stored sproc/record source of the control.
I can do this no problem, but it's getting the line breaks that is proving
I've tried using SELECT [Address1] + CHAR(13) + [Address2] + CHAR(13) +
[Town/City] etc ......
But in the control the CHAR(13) just displays as a box and no line return.
Anyone got any ideas on this one? I would also like to build in the fact
that some of the fields may be null, therefore, I would want nothing
inserted and no line return???? !!!! ????