Ok Access guru's i need your help once again! I have a report that shows a suspense date in it. This is what im trying to do, we have three selections we use on the form when we input the dates. the first is "1 Day" which i need to turn red instantly, the second choice is "4 Days" and i need the date to turn red on the third day and "10 Days" in which i need the date to turn red on the eighth day. so basically we enter dates daily and i need something that keeps track of the date we enter and changes the color of the text on the report on the days shown above. When the days are enter in the form its a drop down menu that lets your select 1 Day, 4 Days, and Ten Days. it takes what you select and adds that many days to todays date and then places it in a table. We run the report daily as well. im a novice vb programmer and im kinda stumped on which way to persue this. Your help would be greatly appreciated.