Conditional formatting continious form

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Filips Benoit
    #1

    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


    Tags: None
    • Tom van Stiphout
      #2
      Re: Conditional formatting continious form

      On Wed, 13 Jun 2007 17:32:19 GMT, "Filips Benoit"
      <benoit.filips@ 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
      >

        Comment

        • Filips Benoit
          #3
          Re: Conditional formatting continious form

          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.spam.tom774 4@cox.netwrote in message
          news:hlc0739e77 supgtmm8487f5f1 rs4gd90qr@4ax.c om...
          On Wed, 13 Jun 2007 17:32:19 GMT, "Filips Benoit"
          <benoit.filips@ 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
          >>
          >

            Comment

            Previous template Next
            Working...