By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Conditional formatting continious form

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.