Weird behavior in continuous

[Benjamin Z. Gregorian]

Hi there

I have a problem with a database I wrote. On my access 2002 it is running
without probs but on the comp of my collegue A2003 there is this weird
behaviour.

The form is a continuous Form which shows in each row a day of a month
For the saturdays and sundays i wanted the row in a different color.
I choose the conditioanal formating for an inputfield which was as wide as
the whole form

With a2002 this works fine!!!!!!!

With a2003 it looks like the form is somehow blinking. I mean i can see that
after drawing the form once A2003 does not stop it draws the form again and
again!!! Really annoying

Had someone else this problem?
How can I find a sollution to that behaviour?

Looking forward to your advice

Benjamin from Jakarta

[Jeff Pritchard]

Actually, I had a similar problem. It was hard to narrow down but it seemed
to be related to overlapping controls (text boxes). It went away after
laying out the form differently. That was in 2000 though, and only the
control blinking, like it was continuously redrawing.

Jeff

"Benjamin Z. Gregorian" <zg***@indosat.net.id> wrote in message
news:bp*************@ID-110095.news.uni-berlin.de...

Hi there

I have a problem with a database I wrote. On my access 2002 it is running
without probs but on the comp of my collegue A2003 there is this weird
behaviour.

The form is a continuous Form which shows in each row a day of a month
For the saturdays and sundays i wanted the row in a different color.
I choose the conditioanal formating for an inputfield which was as wide as
the whole form

With a2002 this works fine!!!!!!!

With a2003 it looks like the form is somehow blinking. I mean i can see that after drawing the form once A2003 does not stop it draws the form again and again!!! Really annoying

Had someone else this problem?
How can I find a sollution to that behaviour?

Looking forward to your advice

Benjamin from Jakarta

[Benjamin Z. Gregorian]

Hi Jeff,

first of all thank you for your reply.

It is really the thing with the overlapping controls!!

Since I need to overlap the controls for the different colors I may not be
able to use this in my form.

Thanks Benjamin

[Benjamin Z. Gregorian]

Hi Jeff,

again many thanks to your response.

unfortunatelly it was not really the solution bacause suddenly it startet to
redraw again even when there was no overlapping of controls.

But I tried again and again different constalations and find the following.

It is because I had as the controlsource a function which give me
weekdaynumber of a date which was in a field of the Query.

Like:
txtDate.ControlSource =DayOfMonth
txtBackground.ControlSource =Weekdaynumber(txtDate)

The controlesources are assigned during the design of the for. Not in
runtime.

So this function is the reason why it starts to redraw again and again.....

I changed the query which is the Recordsource of the Form and added one more
field which already calculates the WeekdayNumber and hands it over to the
Form.

And when I use this newly calulated field which is staticly assined to my
TextBox(Background) then the form is also stable and it draws just once and
thats it!!

I still dont know why this behaviour but I found a solution to my problem!!!

Thanks
Benjamin