how do I increase a query field size to more than 255 characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query based on a table. the table contains a field which holds a
large amount of text data, so I have set its data type to Memo. No problem.
But the query will only display (and export) the first 255 characters of the
large amount of text in each record, and I cannot find any method to increase
this, despite searching high and low in the Help sections etc, but logically
speaking there must be a way of doing it.
I could work without the query I suppose, and pull the info straight of the
Table, but I would prefer not to. Please advise.
 
It might help if you offered up a view of the SQL of your query. You might
have phrases like "DISTINCT" or "GROUP BY" or other that would limit the
number of characters.
 
Back
Top