Storing Carriage Returns in Access Table

[TechmanJoe]

I'm trying to use an SQL query to store a multi-line field containing carriage returns in an Access table. However only the text up to the first the carriage return gets stored. I'm assuming this is because carriage return denotes the end of a record. Is there a way around this? Thanks!

Joe

 

[earthandfire]

It should not be a problem. What is the datatype and size of your field.

 

[TechmanJoe]

Data Type: Text
Field Size: 255

 

[traingamer]

How are you putting carriage returns in your SQL?
See thread701-1039020 among other similar threads.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[RoyVidar]

Are you completely sure?

What happens if you go to the table, place the cursor within the field (F2), then try downarrow?

Or show the field in a form/report in a text control allowing more than one line?

Roy-Vidar

 

[southbean]

TechmanJoe,

Did you import your data from Word or Excel? If so, a CR in Excel is different than a CR in Access. See this MSDN link to convert the CR into one Access can handle.

[blue]

http://support.microsoft.com/default.aspx?scid=kb;en-us;210372

[/blue]

Hope this helps,

- Tom