I don't have much to add, just didn't want you to think no one is 
reading your request

I have a table with about 20'000 records, 256 fields and the last 10 or 
so are all formatted memos. Everyone of these memo fields are constantly 
being edited and formatting is used, too much.

Anyways, I did have some kind of corruption in one of the fields, I 
found what it was but there were too many records to change so we just 
left it alone and the users all have instructions on what not to do. 
Someday it will clean itself up. Anyways, we have not had any futher 
problems. I did follow some advice to put the memo fields at the end of 
the table.

FWIW

Peter

On 04/23/2019 10:55 AM, Steven Green wrote:
> formatted memo fields.. opinions, please, aside from "don't use them" :-)
> 
> in this instance, they're usually 1k to 2k in size, and the guy who 
> designed the tables made them all F240.. 99% of the use is for reports, 
> so if I change them from F to M, I have to format the text in a 
> gazillion reports, instead of just letting it pass itself thru from the 
> tables.. not today
> 
> do you think the table structure will be more solid if I change the 
> table part to F1, F10, etc.. something small.. the full content is way 
> more than the 255 alpha field limit, most of the time, so I'm thinking 
> it's just gonna make MORE I/O traffic.. but it's always gonna open the 
> table and the memo, either way
> 
> this is all just theory, of course
> 
> -- 
> 
> Steven Green
> Myrtle Beach, South Carolina, USA
> 
> http://www.OasisTradingPost.com
> 
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too