Turn off screen updating

[DaveJHPT]

I've had a search and can't find anything along these lines...

I've got some code which plays about with reports and it looks awful when it's running - is there an equivalent of Excel's "Application.ScreenUpdating = False" functionality in Access (2000)?

Dave

 

[ghudson]

The Echo command is what you want. Ensure you put an Echo = True in your error handler for the db will appear to be locked if the user hits a runtime error while the echo is turned off. Check the Access help files for more info and examples of using Echo.

 

[DaveJHPT]

Thanks very much.

I've noticed something odd - "Echo false" suppresses the display of the report in design mode OK, except for the Field List which pops up and disappears again! Got round it by opening the report in design mode, closing the field list and saving again, but rather an odd feature...

Dave