Carriage Return

[Matthew DeAngelis]

Does anyone know how to insert a carriage return in a SQL statement? I
have tried Chr(13), but it gets ignored.


Thanks,
Matt

 

[Matthew DeAngelis]

Does anyone know how to insert a carriage return in a SQL statement?
I have tried Chr(13), but it gets ignored.


Thanks,
Matt

I have also tried chr(13) & chr(10). Here is the full string:

UPDATE [tbl: Data - Deals] SET [tbl: Data - Deals].ConcatMemoField =
Nz([ConcatMemoField],'Technology: ' & [tbl: Data - Deals].Technology &
chr(13) & chr(10) & 'IP: ' & [tbl: Data - Deals].IP & chr(13) & chr(10)
& 'Business Model: ' & [tbl: Data - Deals].BusinessModel & chr(13) &
chr(10) & 'Issues: ' & [tbl: Data - Deals].Issues & chr(13) & chr(10) &
'Market Opportunity: ' & [tbl: Data - Deals].MarketOpportunity);


Thanks,
Matt

 

[Glenn]

Matthew,

Try & Chr(13)+Chr(10)

instead of & chr(13) & Chr(10)

Rgds,
Glenn

-----Original Message-----

Does anyone know how to insert a carriage return in a SQL statement?
I have tried Chr(13), but it gets ignored.


Thanks,
Matt

I have also tried chr(13) & chr(10). Here is the full string:

UPDATE [tbl: Data - Deals] SET [tbl: Data - Deals].ConcatMemoField =
Nz([ConcatMemoField],'Technology: ' & [tbl: Data - Deals].Technology &
chr(13) & chr(10) & 'IP: ' & [tbl: Data - Deals].IP & chr (13) & chr(10)
& 'Business Model: ' & [tbl: Data - Deals].BusinessModel & chr(13) &
chr(10) & 'Issues: ' & [tbl: Data - Deals].Issues & chr (13) & chr(10) &
'Market Opportunity: ' & [tbl: Data - Deals].MarketOpportunity);


Thanks,
Matt
.

 

[Matthew DeAngelis]

Chr(13)+Chr(10)

Glenn,

Still no luck. The query continues to ignore the characters, inserting
nothing at all between the fields. I tried putting the above in quotes
as well, also with no success.

I find this very strange. Thank you anyway.


Matt

 

[Matthew DeAngelis]

Does anyone know how to insert a carriage return in a SQL statement?
I have tried Chr(13), but it gets ignored.


Thanks,
Matt

I figured it out...the null function was the problem. Using a regular
insert statement, both characters work just fine.


Thanks,
Matt