I have some unbound images that I am setting as the report is shown. It comes up with a screen that says "Importing: ....". The problem I am having is after a certain amount of reports it is giving me an error because the jpg is too big, but if I just print preview on that report it works just fine. So I am thinking as Access imports the images it accumulates and runs out of memory at a certain point. Is there away to clear the memory being used when the report closes and goes to the next report?
Here is a sample of the code I am using
If IsNull(Forms("SpecialStructureForm").[Picture1]) = False Then
Forms("SpecialStructureForm").imgPicture1.Picture = Forms("SpecialStructureForm").[Picture1]
Else
Forms("SpecialStructureForm").imgPicture1.Picture = ""
End If