Carriage Return

  • Thread starter Thread starter Matthew DeAngelis
  • Start date Start date
M

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 said:
Does anyone know how to insert a carriage return in a SQL statement?
I have tried Chr(13), but it gets ignored.


Thanks,
Matt
Click to expand...

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,

Try & Chr(13)+Chr(10)

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

Rgds,
Glenn
-----Original Message-----
Matthew said:
Does anyone know how to insert a carriage return in a SQL statement?
I have tried Chr(13), but it gets ignored.


Thanks,
Matt
Click to expand...

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
.
Click to expand...
 
Glenn said:
Chr(13)+Chr(10)
Click to expand...

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 said:
Does anyone know how to insert a carriage return in a SQL statement?
I have tried Chr(13), but it gets ignored.


Thanks,
Matt
Click to expand...

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


Thanks,
Matt
 
Back
Top