Memory Error when printing report

[Dirtrider929]

I am getting an error message when printing a 2 part report. It does not appear until I have already printed the first part and I am ready to print the second. I have 6 users and all seem to experience intermittently with the exception of 1 who it is constant. The message is as follows;

"There isn't enough memory to update the display. Close unneeded programs and try again."

I have tried deleting the registry "KEY_CURRENT_USER\Software\Microsoft\VBA" with no avail and have installed all available updates from MS.

Any help please. I am at my wits end. Thank you.

 

[BlueIshDan]

does this person have more ram on their computer and are you using custom public functions in your queries on each record.

 

[Dirtrider929]

The person has 4G RAM and yes custom fuctions are used.

 

[BlueIshDan]

My best guess is that you're causing a memory leak.
Try designing the process around a memory efficient manor. Recursive functions definitely cause memory leaks. Make an algebraic style process rather than a recursive one. Clear memory where appropriate.