Flickering screen on continuous form

[Rob]

Hoi, I have a problem with a flickering screen for continuous forms.
I have a continuous form with some fields based on a normal record source.
One of the fields on the form has a control source like this
=Myfunction(a;b)
where a and b are fields from the record source.
this field has no Conditional formating set to it.

and where Myfunction basicaly is declared in a module like this:
Public Function Myfunction(myvar1 as integer; myvar2 as integer)
Myfunction = myvar1 * myvar2
end function

Now this works very well on my development computer, but when i transport
the database to an old pentiumIII with almost the same software environment
and run the database, the continuous form comes up (with correct awnsers, by
the way) but the form is flickering, rebuilding itself all te time.
All other continuous forms work very well on this old computer.

Can anyone see wath i am doing wrong?
Any help would be appreciated,
(sorry, i also posted this message in the general database group)
Rob

 

[Larry Linson]

Do the other continuous forms that work OK have similar Calculated Controls?

What happens if you remove the Field with the Control Source of
=Myfunction(a;b)? If the flickering stops, then it is the
processing/calculation that is intefering with the display.

If that is the case, then can you move the processing to the Query as a
Calculated Field, instead? Does it help?

Larry Linson
Microsoft Access MVP

 

[Rob]

Thanks Larry for your reply,
Actualy, when i removed the control source of the calculated field the
flickering disapairs...but i now found out that one of the other
non-calculated fields on that form did have a conditional formating on it.
Removing this conditional formating did do the trick.

So one cannot use such a calculated field on a continuous form if there is
ANY conditional formating elsewhere on the form......don't ask me why....ask
Bill...
Thanks anyhow.....

 

[Larry Linson]

So one cannot use such a calculated field on a continuous form if there is
ANY conditional formating elsewhere on the form......don't ask me
why....ask
Bill...

I'll have to disagree. That is definitely NOT a rule, not even a "rule of
thumb."

Just to confirm for myself, I created a continuous forms view with a
calculated field and a field with conditional formatting, which ran with no
flicker at all on my vintage February 2005 notebook computer (which possibly
has a faster processor than your Pentium III, but is no 'great shakes' for
video).

I am reasonably certain that it's just a matter of the combination of
computer, OS, video card, display, and video drivers being able to keep up
with the processing required to create the display, and the number of
records involved.

Larry Linson
Microsoft Access MVP