How to manage memory problems to see more than 500KB in just one field in the screen?

[Ricardo de Mila]

I have made a small application in Acces that nowadays is more than 70Mb big.
In a function of the software, I have to transform a lot of records in just one text that has more than 500KB. The reason for viewing such information is that it is a history acumulated from some years and some times must be analysed at once.
I can put everything togheter in the record, but when I try to see the content in the screen, I get a message "Out of Memory".
How can I manage a lot of memory in just one simple record?
Best Regards
Ricardo de Milano

[TheSmileyCoder]

Hi and welcome to Bytes

Im assuming your data is text (memo field) and can't help but wonder why you would want to display 500k of data?

Memo fields can hold alot of data (I think the limit is 2million charecters, but don't remember for sure) but can only display 64.000 charecters. Im guessing this is what your experiencing.
Also using the standard access interface you will only be manipulate strings of (max) 64.000 charecters, while using code you can manipulate larger strings.

Now I dont know what your function does, but if you dont need to display the value, you can handle the processing "behind the scenes". You will need to supply some more information to help you further.

If your access database is growing, you can do a "Compact and Repair" to free up unused space.

[Ricardo de Mila]

Thank you very much.
I think I handle from here.
The doubt is solved.
Best Regards Ricardo de Milano