I have a report that accepts a date range and a parameter that tells it WHO (e.g. everyone, a unit, or a person). The calling form passes these to the report. The report is working great for all permutations of date ranges and who... except for one case. For that case, the report comes up (no errors, no problems), but some of the textboxes are completely blank!

The report calculates values (stats) based on the date range and who I'm interested in. One of the options for date range is "from the start of this project to today." When I chose that together with "everyone" for the WHO part, I get blank textboxes for some of the items. I even made sure the textboxes are wide enough to handle displaying the values (low 2000s). If I choose any other combo of date range and who, I get values and they're fine.

If I let the report run without stepping through, the values do not appear and this oddity does print on the paper, too. If I step through the VBA and trace the values that are not displaying properly, I can see that they are calculating correctly. Once the stepping through is done and the report displays... the values are all there! Showing! To add salt to the wound, if I click the PRINT button, the report does NOT print. It behaves as though it does, but nothing comes out. It won't even print to PDF.

I have tried creating a new database and importing all to it to see if that would help this quirky behavior, but no luck.

Has anyone ever experienced something like this before?

This may not be worth pursuing, but I would see if the values come up in the form.

In my experience, anytime data is not on the report it is somehow not GETTING there or not getting there in the proper sequence.

Make sure your query puts the correct data out also. In other words, check the data going to the report. I understand it LOOKS like it is but maybe not.

Milt

I would say try running it with less data. Post the code that you are stepping through.

Robert