Data Type field

  • Thread starter Thread starter Angel_G
  • Start date Start date
A

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.
 
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.
 
Back
Top