Smooth Refresh of calculated control

[amstelburger]

Hello everyone,

Is there any way to refresh a calculated control in a smooth fashion,
that is without having the control "empty" for - if only - just a split
second? I use a lot of them on my forms, but when they get refreshed
their contents flicker, because they briefly disappear before being
updated, making my form look kind of "restless", for lack of a better
word...

Thanks in advance

[Nick 'The Database Guy']

am**********@yahoo.com wrote:

Hello everyone,

Is there any way to refresh a calculated control in a smooth fashion,
that is without having the control "empty" for - if only - just a split
second? I use a lot of them on my forms, but when they get refreshed
their contents flicker, because they briefly disappear before being
updated, making my form look kind of "restless", for lack of a better
word...

Thanks in advance

Hi Amstel Burger,

The best way to acheive this is to turn off the screen updating while
you update the control. You can do this with the 'Docmd.Echo False'
command, after you update the control you obviously must turn on the
screen updating again with the 'Docmd.Echo True' command.

Regards,

Nick

PS Beer and McDonalds?

[amstelburger]

Nick 'The Database Guy' wrote:

am**********@yahoo.com wrote:

Hello everyone,

Is there any way to refresh a calculated control in a smooth fashion,
that is without having the control "empty" for - if only - just a split
second? I use a lot of them on my forms, but when they get refreshed
their contents flicker, because they briefly disappear before being
updated, making my form look kind of "restless", for lack of a better
word...

Thanks in advance

Hi Amstel Burger,

The best way to acheive this is to turn off the screen updating while
you update the control. You can do this with the 'Docmd.Echo False'
command, after you update the control you obviously must turn on the
screen updating again with the 'Docmd.Echo True' command.

Regards,

Nick

PS Beer and McDonalds?

Hi Nick,

Thanks for the reply. I had already tried that for a number of times
but unfortunately, that doesn't do the job. I don't know why, maybe
that only works if a control's content is directed bij VBA, that's what
it looks like to me anyway.

PS The real "Happy Meal" ...

[google-post]

The only way I found to do this reliably (using Access97) was to use
the Picture command to change the picture contents in a image. Echo
never really helped for rapid updates. I use this method to update the
play-time counter (updated more than once a second) in the mp3-boss
application. You may want to take a look at that application to see
the results -- since calculating the results and then manipulating bmp
images is a lot of work!

Instead of going to the trouble of using picture controls...updating
the contents less frequently, or using a faster computer, makes the
flicker much less obvious.

John
http://www.mp3-boss.com