Form Calculation Timing

  • Thread starter Thread starter MTHarris
  • Start date Start date
M

MTHarris

Can anyone help explain why in the form I have created which has several
calculation fields do not update calculation until I move my mouse over the
form? I know this question sounds really lame? but thought I would ask
anywho..

Any help appreciated

MTHarris
 
This may actually be a problem with the display of the values, rather than
the recalculation of the values.

To test that idea, open the Immediate Window (Ctrl+G) and ask what is in the
problem controls, e.g.:
? Forms("MyForm").Controls("MyControl").Value
If the value is different from the display, it's a display problem. (Note:
merely switching to the Immediate Window might make Access update the
display.)

Another angle: If it is fixed by:
Me.Repaint
it is a display problem; if it requires:
Me.Recalc
it is a calculation problem.
 
Back
Top