User Profile

Collapse

Profile Sidebar

Collapse
kevinj
kevinj
Last Activity: Nov 13 '07, 12:39 AM
Joined: Jun 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kevinj
    replied to Changing field color based on date data for each record
    in Access
    Linq,

    Thanks for the info. I am using a continuous form as the goal is to see many records at the same time. Do you know if there is a way to do this using a report instead of a form maybe?

    Thanks!
    See more | Go to post

      Leave a comment:

    • kevinj
      started a topic Changing field color based on date data for each record
      in Access

      Changing field color based on date data for each record

      Greetings,

      I am creating a "stoplight" type report that is based on the number of days between dates, the field will be highlighted in red, yellow, or green. I am able to change the background color on the textbox, but each subsequent record is set to the color as determined by the first record. Is there a way to do this for each record? I am using access 97. My code is something like this (I'm going off of memory as...
      See more | Go to post
      No activity results to display
      Show More
      Working...