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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Field Data 7
Memo field 1
Restoring line breaks in memo field 1
Change Memo data type to Text data type 1
How to subtract a number from a Mergefield? 0
Why does my memo field truncate the data? 6
Split data in field on character return 0
Carriage Returns... 2

Back
Top