Can you or how do you increase the size of a memo field?

[bmoberly8888]

We have time entries with narratives. I am writing a report and need the entire narrative - however if the narrative is longer than 255 - it just stops. Is there a way to increase the field so I can get the entire entry?

 

[PHV]

Use a memo field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bmoberly8888]

It is a memo field - but I don't know how to increase the size to more than 255 characters.

 

[PHV]

A memo field is limited to 64k characters BUT get truncated to 255 when used in a GROUP BY clause, as argument in an aggregate function or when the DISTINCT predicate is used or ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886