Requery without visibility change

  • Thread starter Thread starter stickandrock
  • Start date Start date
S

stickandrock

I have a on Timer event on a form.

Within that logic I am performing a requery function on a number of fields.
When you requery the field goes from visable to not visable back to visable
with the refresh totals.

My problem is I am doing this requery on 26 fields on form. It's ALOT of
blinking. A bit distracting. Is there a way to perform the Requery without
the visibility change. just have it refresh the value.

Much appreciate as always.....
 
On Fri, 28 May 2010 07:26:02 -0700, stickandrock

Maybe you can wrap your code with:
Me.Painting = False
....your refresh code
Me.Painting = True

-Tom.
Microsoft Access MVP
 
still doing the same... Seems like it would work though...

between the Red/Green Conditional formatting and the blinking - I had to
laugh, looks like a Christmas tree..

keep the ideas coming. Still searching online myself to come up with a plan.
 
Are you performing the requery on each of the 26 controls? If so why not
just requery the form or even just Me.Requery. That way everything gets
updated in the same cycle.

Regards

Kevin
 
stickandrock said:
I have a on Timer event on a form.

Within that logic I am performing a requery function on a number of
fields.
When you requery the field goes from visable to not visable back to
visable
with the refresh totals.

My problem is I am doing this requery on 26 fields on form. It's ALOT of
blinking. A bit distracting. Is there a way to perform the Requery
without
the visibility change. just have it refresh the value.

Much appreciate as always.....
Click to expand...


What sort of expressions do you have in those controls? Maybe Me.Recalc
would recalculate them all.
 
Back
Top