What is the process? If it is a query (which means you cannot know how long it will take thus you cannot assign a percentage) control passes from the part of Access that contains your form to the part that processes your query. This means you cannot update the control until flow returns to the form that contains it, making it pointless.
AFAIK, this control is really only for processes whose length is known, or where the procedure that is running does not pass control to somewhere else, thus it can control the length of the progress bar.
Last edited by Micron; 03-27-2017 at 01:52 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.