DCount results only display on form when mouseover

  • Thread starter Thread starter David Bretzke
  • Start date Start date
D

David Bretzke

Hello---

I have a form (data statistics form) with several fields using DCount
calculations. Most of these are based on a few queries with different
parameters. When building it, I switch back and forth from the Design view
to the Form view and everything works properly....a little delay (usually
less than 1 seconds) to calcuate and show up on the form.

I now open the form from a different form, most of the fields (all of which
are based on queries--the ones based on a table show immediately) do not
display the counts unless I mouseover the field and then they report the
results. It's not that big of a deal, but quite annoying...and possibly
problematic for those who need the counts and don't wiggle their mouse over
the form. I tried to set the focus to one, and it works for that field 7 out
of 10 times, but nothing for the others.

Any other ideas?

Thanks!

Dave
 
Dave, the fact that wiggling the mouse over the field fixes the issue
suggests that it could be a video driver issue. To test that idea, switch to
using a vanilla VGA driver, or test on a computer with a totally different
video chipset. If that solves the problem, download an updated driver, or
turn off some of the hardware acceleration.

If that does not solve the problem, see if the problem is solved with a
Repaint (forcing the screen to redraw) or a Recalc (forcing the calculated
controls to calculate again). You could also try opening the Immediate
window (Ctrl+G) and asking it what is in the calculated control, e.g.:
? Forms![MyForm]![MyCalcTextbox]
If the value is present, that should show. If it is a display problem,
merely switching to the immediate window and back might cause Access to
repaint.

There are some display issues in Access, but the symptoms I am aware of do
not match your case. Details in:
Incorrect display of data
at:
http://allenbrowne.com/bug-06.html
 
Thanks for the assistance. I tried it on 3 different computers in and out of
the office and it still does it. I started messing around with Popup & Modal
properties on the form (StatsForm) and the form calling the StatsForm. Found
something here, but the presence of the Switchboard made it unuseable (the
calcs shwed on the form, but the form was behind the Switchboard).

I found a work-around....When opening StatsForm from Form1, I simultenously
close Form1 from code. Secondly, I close StatsForm and simultenously reopen
Form1. This makes things work fine again.

Again thanks for the help.

Dave




Allen Browne said:
Dave, the fact that wiggling the mouse over the field fixes the issue
suggests that it could be a video driver issue. To test that idea, switch to
using a vanilla VGA driver, or test on a computer with a totally different
video chipset. If that solves the problem, download an updated driver, or
turn off some of the hardware acceleration.

If that does not solve the problem, see if the problem is solved with a
Repaint (forcing the screen to redraw) or a Recalc (forcing the calculated
controls to calculate again). You could also try opening the Immediate
window (Ctrl+G) and asking it what is in the calculated control, e.g.:
? Forms![MyForm]![MyCalcTextbox]
If the value is present, that should show. If it is a display problem,
merely switching to the immediate window and back might cause Access to
repaint.

There are some display issues in Access, but the symptoms I am aware of do
not match your case. Details in:
Incorrect display of data
at:
http://allenbrowne.com/bug-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

David Bretzke said:
I have a form (data statistics form) with several fields using DCount
calculations. Most of these are based on a few queries with different
parameters. When building it, I switch back and forth from the Design view
to the Form view and everything works properly....a little delay (usually
less than 1 seconds) to calcuate and show up on the form.

I now open the form from a different form, most of the fields (all of which
are based on queries--the ones based on a table show immediately) do not
display the counts unless I mouseover the field and then they report the
results. It's not that big of a deal, but quite annoying...and possibly
problematic for those who need the counts and don't wiggle their mouse over
the form. I tried to set the focus to one, and it works for that field 7 out
of 10 times, but nothing for the others.

Any other ideas?

Thanks!

Dave
Click to expand...
Click to expand...
 
Back
Top