thanks, Peter.. ditto to your comment, too.. many are heavily edited, 
changing it all is a potential nightmare, day-to-day instructions they all 
know about.. including how to get everyone out of Paradox to rebuild the 
damn tables

(sigh)

--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Peter"  wrote in message news:5cbf7625$1@pnews.thedbcommunity.com...

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