Screen updating ms access

Screen Updating = True End Sub Sub Convert Endnotes To Comments() Application.

Tags: Microsoft Access Developer, Microsoft Access Development, Microsoft Access Help, Microsoft Access VBA, recalc, refresh, requery This entry was posted on Tuesday, August 17th, 2010 at pm and is filed under Uncategorized.

You can follow any responses to this entry through the RSS 2.0 feed.

Screen Updating = False Dim obj Footnote As Footnote Dim obj Range As Range Dim obj Doc As Document Set obj Doc = Active Document With obj Doc For Each obj Footnote In .

This means that the Word screen can look like it has "gone crazy" while the macro is running.

Screen Updating = True ''//Turn on screen updating End Sub Text boxes in worksheets are sometimes not updated when their text or formatting is changed, and even the Do Event command does not help.