Any way to suppress flickering of a datasheet? (Access 2003)

[Yarik]

Hi,

This is about an alternative to the property Painting of the Form
class.

As documentation says, this property has no effect when the form is in
datasheet view. It is very sad (for example, because our users are
getting sick of unnecessary flickering in response to a call to Recalc
method).

Is there any reasonably maintainable and reliable trick (like using
Windows API or something) to circumvent this problem?

Thanks,
Yarik.

 

[Arvin Meyer [MVP]]

I have never noticed any flickering of the screen, but that may be because I
have lots of memory and a good video card. You might try using:

Echo Off

to proceed your recalc code, then turn it back on when you're done.

 

[Yarik]

I have never noticed any flickering of the screen, but that may be because I
have lots of memory and a good video card.

I really doubt that memory or video have anything to do with that. I
think it's just that recalculation of control values is very slow in
Access (I mean controls whose values are calculated by calling VBA
procedures).

You might try using:

Echo Off

I tried, but it also does not seem to have any effect when the form is
in datasheet view... :-(