Turn Screen Updating off and on in Access

[Paul H]

Does Access have a syntax comparable to Excel's Application.ScreenUpdating = False (or True)



In my application I put my report into design mode to make some changes, save it and then reopen it in print preview. The process takes about 2 or 3 seconds, long enough to observe the design view and property box. I think this looks kind of tacky and I would like hide it till it is finished.

Can this be done?

[pbaldy]

I'm curious why you do it, as that technique won't work in some environments. In any case, OpenReport has an argument that will let you open the report hidden.

[Paul H]

Well, it was the only way I found to set the rowsource and other properties on the charts in my reports. Any other way I tried resulted in run-time error 2451, "The report 'myreport' you entered is misspelled or refers to a report that isn't open or doesn't exist." if it is closed or run-time error 2771, "The bound or unbound object frame you tried to edit does not contain an OLE object." if it is already open. I don't get any errors when I put it into design view.

I wasn't aware of the keep hidden option. That works just fine, but I am open to it if you have them.

[pbaldy]

If it's working for you, I guess I'd leave it alone. I suspect you'll have problems if you ever want to provide users with an mde/accde or have users with the runtime version of Access. I don't think the code will work in either scenario. If you get there, I'd try changing the settings in the open event of the report. That's where I do dynamic record sources and such. It should also be faster, since you wouldn't be opening/closing/opening the report.

[Paul H]

I see your point(s). I'll give that a try when time allows.

[Paul H]

Here's a twist. This report is likely already open. I am using a pop up form over the report to update it on request. I don't see anyway around closing the report first and reopening it, at least under this current scenario. These are all charts and I had embedded them in a form (much simpler), but they also want to print them as reports, so I canned the embedded form in favor of hovering over and updating the reports. It's been along torturous journey, but no method I've found so far has been without its drawbacks. Using the embedded form was much smoother, but I had to maintain duplicate of each chart on a report which comes with it's own set of problems.

[pbaldy]

Sounds tricky. If it's open in Preview mode, it's static and you probably do have to close it first. The new Report view is interactive, so you might be able to leave it open there. I've only used that a couple of times, when I wanted the look of a report with the interactivity of a form (though it is read only). I know you can change its record source while its open.