I have a Master Table that is linked in from SQL. The Datatype of the column I am having trouble with in SQL is Text. I link the table into Access and when I look up the datatype of the troublesome column in Access, it is Memo (some fields go up to almost 800 char). I then make a query using this table and when I run the query, the "Memo" field shows all of the characters. Then when I build a report based on this query, it cuts it down to 255!!! I have looked on a lot of forums and here are things I remember I have done and double checked and it still doesn't work:
Unicode compression set to Yes
No format (anywhere!!)
No *, DISTINCT, UNION or similar in the query
Use First, not Group By
I have tried expressions like Left([MemoField], 800) in the query and report
Unique values set to no
No crosstab query or summary query (if other fields have group by, is it automatically a summary query?)
Grow/Shrink set to yes
Does anybody have any other bits of knowledge? Thank you for any and all help.
Unicode compression set to Yes
No format (anywhere!!)
No *, DISTINCT, UNION or similar in the query
Use First, not Group By
I have tried expressions like Left([MemoField], 800) in the query and report
Unique values set to no
No crosstab query or summary query (if other fields have group by, is it automatically a summary query?)
Grow/Shrink set to yes
Does anybody have any other bits of knowledge? Thank you for any and all help.