Requry of a form onTimer makes the text blink

[Larsson]

Hi!
I am currently making a very simple chat program for my users in Access. So I have a form that displays all the messages in the table and this form has a timer with 1 second. I do a requery of the form on the onTimer event and this makes the text blink. This is very annoying.

Is there anyone who know why and how I can make it stop blink?

Larsson

 

[hermanlaksko]

If you requery the form the text will blink, whey not requery the field you want to update only.

 

[Larsson]

The text stop blinking but the new posts didn't show up.

Larsson

 

[krsherm]

You can tell Access not to refresh the screen while the form is requerying. That will keep the screen from flickering. To do so, try this code snippet:

Application.Echo = False 'turn off screen updating

Forms!myForm.Requery 'Requery the form

Application.Echo = True 'turn screen updating back on

Rock ON!

Kevin

 

[Larsson]

I will have to test this on Monday.