Requery without visibility change

[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.....

 

[Tom van Stiphout]

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

 

[stickandrock]

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.

 

[kc-mass]

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

 

[Dirk Goldgar]

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.....

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