Search results

I haven't tried this but this would be the route I would explore: Create a variable like Dim Mydate1 as Date Mydate1() = recordsourcename.mydate and then a select statement like Select Case MyDate1() Case is < "1/1/2000" 'change back color Case is > "1/10/2000" 'change back color...

Hey, I find answers sometimes to some of my interesting questions so I thought I would register. USA. Currently do access 07 / 10 on either the native Joint Engine Technology (JET) back end that comes with Access or SQL Server w/ Access as a front end tool.