only getting first 256 characters

[evilmousse]

I have a simple query to pull a large comments field. the query succeeds in drawing in all the data when the query is bound to a form or report, but when I run it in query analyzer or try to output the query to excel, i only get the first 256 chars of the field.

what shall i do?

-g

 

[thobholl]

I may be mistaken, but I believe that the Access is limited to 255 + 1 characters per field. Tables will not let you increase the size of a text field to more than 255.

I think there is a work around with code - check google for "use more than 255 characters in access"

 

[dhookom]

I believe this is an issue/limitation with Excel. If you truly meant SQL "query analyzer" then there is a property that allows you to set the maximum number of characters per column.

Access tables, queries, forms, and reports allow you to display pages of characters in memo fields.

Duane
MS Access MVP

 

[evilmousse]

Yeah, with the hints I've gotten from different sources, I've found it is a limitation of Access. It always creates the excel file as excel 95 (a dll prob i bet) even when you choose to save it as a newer ver. I've seen more complex solutions that'd amount to duplicating the docmd's work, but I don't have the time right now. So i'm parsing the field into two for now.
Query analyzer's behavior is just a property, and can be set.

-g