When referring to Jet reports, what is the difference between
"Design Mode" and "Report Mode"?
A report is is Report Mode when the report has been run (using either the Run or Run from Cache option) and the Go to Design button is displayed:Changes should not be made to a report while it is in Report Mode, as those changes will be lost as soon as the report is run.
When a report is being designed and the Design button is displayed...
the report is referred to as being in "Design Mode".
Only licensed Designers have direct access to Design Mode (that is, a report that has been saved in Report Mode can only be switched to Design Mode by a licensed Designer).
Design Mode is used to create and make changes. When the report is then run (and placed into Report Mode), the results of those changes will be reflected.
While in Design Mode, Jet function results are optimized for speed and are not guaranteed to accurately reflect the results of all queries. Use Report Mode to ensure you are viewing accurate data.