scottmfitzge
Registered User.
- Local time
- Today, 22:59
- Joined
- Jun 3, 2008
- Messages
- 31
Hi
,
I wonder if someone is able to help me as i am really stuck on this problem with my database. I have created the database in Access 2003. On one of the forms in the database, i want the "Date" field border to be displayed a different colour, dependent on how long the record has been in the database compared to the date in the "Date" field.
If the record has been in the database for < 2 weeks i want the border to be green, if the record has been in the datbase for 2 weeks or more i want the border to show as Yellow, if the record has been in the databse for 4 weeks or more i would like the border to be amber/orange, and if the record has been in the database for 6 weeks or more, red.
First of all, is this actually possible? and if it is possible does anyone know the VBA code that i would have to put in the event procedure, and if so which 'event' would be best to use in this scenario....
Really appreciate your help on this guys, i have always been able to find a resolution on here for my Access problems, but am really stumped on this one
.
Cheers
Scott

I wonder if someone is able to help me as i am really stuck on this problem with my database. I have created the database in Access 2003. On one of the forms in the database, i want the "Date" field border to be displayed a different colour, dependent on how long the record has been in the database compared to the date in the "Date" field.
If the record has been in the database for < 2 weeks i want the border to be green, if the record has been in the datbase for 2 weeks or more i want the border to show as Yellow, if the record has been in the databse for 4 weeks or more i would like the border to be amber/orange, and if the record has been in the database for 6 weeks or more, red.
First of all, is this actually possible? and if it is possible does anyone know the VBA code that i would have to put in the event procedure, and if so which 'event' would be best to use in this scenario....
Really appreciate your help on this guys, i have always been able to find a resolution on here for my Access problems, but am really stumped on this one

Cheers
Scott