468,307 Members | 1,329 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,307 developers. It's quick & easy.

Conditional formatting continious form

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
Jun 13 '07 #1
2 2816
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
Jun 13 '07 #2
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

Jun 13 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bradley | last post: by
8 posts views Thread by Dimitri Furman | last post: by
2 posts views Thread by Von Bailey | last post: by
5 posts views Thread by Andrew Chanter | last post: by
reply views Thread by GGerard | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.