Tom,
All dayfields 1>31 ( or less depending the month) has 3 conditions in
conditional formatting. If less days the orther dayfields are set to
unvisible by code.
If value = "WK" then color1 (weekend)
If value = "NH" then color2 (national holiday)
If value = "H" then color3 (holiday)
If there are less than 10 records no problem.
More records, the result is not predictable, some rows are formatted
correctly others are not.
Even in 1 row 1 field is formatted OK others are not.
Somethimes the screen refreshes without demand.
While scrolling the result of conditional formatting is unpredictable.
I can't see any logical patern.
Filip
"Tom van Stiphout" <no*************@cox.netwrote in message
news:hl********************************@4ax.com...
On Wed, 13 Jun 2007 17:32:19 GMT, "Filips Benoit"
<be***********@telenet.bewrote:
What I have seen is that on larger recordsets (1000 rows) the
formatting would be lagging by a second or two. Is that what you mean
by "fail"?
-Tom.
>>Dear All,
Access 2003 adp on SQL_server 2005
A continious form showing 1 month based on table 'CALENDAR_MONTH_GRID' and
fill with a SP.
Fields: Companyname, Day1, day2, etc.
The value in the day-fields is like WK (weekend), NH (National holiday),
etc.
Depending on the fieldvalue the field is colored using conditional
formatting.
Works fine on test with a small number of records.
BUT, now while using this new form and lots of records (companies) the
conditional formatting fails.
Especially when scrolling .
What to do?
Thanks,
Filip