Data Type field

[Angel_G]

Can anyone help me figure out how to change the data type on a field in a
query from Text to Memo. The query pulls the data from a linked ODBC
connection to a SQL table.The field is a Memo type data field but some how
it is coming across with symbols for every carriage return and was told that
I needed to change the data type on my queries to Memo. The name of the
field is ExtendedText.

 

[Douglas J. Steele]

It's doubtful that changing from Text to Memo will change that behaviour.
Access needs a carriage return and a line feed in that order: Chr(13) &
Chr(10) or vbCrLf. If the original data source doesn't have that restriction
(if, for example, it only uses a carriage return), you'll get the behaviour
you're describing.