You can use the RepaintObject macro action in Access databases to complete any pending screen updates for a specified database object or for the active database object, if none is specified. Such updates include any pending recalculations for the object's controls.
Setting
The RepaintObject macro action has the following arguments.
|
Action argument |
Description |
|
Object Type |
The type of object to repaint. Click Table, Query, Form, Report, Macro, Module, Data Access Page, Server View, Diagram, Stored Procedure, or Function in the Object Type box in the macro design window. Leave this argument blank to select the active object. |
|
Object Name |
The name of the object to repaint. The Object Name box shows all objects in the database of the type selected by the Object Type argument. If you leave the Object Type argument blank, leave this argument blank also. |
Remarks
Access waits to complete pending screen updates until it finishes other pending tasks. With this action, you can force immediate repainting of the controls in the specified object. You can use this action:
-
When you use the SetValue macro action to change values in a number of controls. Access might not show the changes immediately, especially if other controls (such as calculated controls) depend on values in the changed controls.
-
When you want to make sure that the form you are viewing displays data in all of its controls. For example, controls containing OLE objects don't display their data immediately after you open a form.
-
This action doesn't cause a requery of the database, so it doesn't show new and changed records or remove deleted records from the object's underlying table or query. Use the Requery macro action to requery the source of the object or one of its controls. Use the ShowAllRecords macro action to display the most recent records and remove any applied filters.
-
The RepaintObject macro action doesn't have the same effect as clicking Refresh in the Records group on the Home tab, which shows any changes you or other users have made to the currently displayed records in forms and datasheets.
To run the RepaintObject macro action in a Visual Basic for Applications (VBA) module, use the RepaintObject method of the DoCmd object.
