Question MS Access 2007 Dates (1 Viewer)
- Thread starter pbrydone
- Start date
Success at last!! Many thanks to everyone for their help (and patience). Can I be bold and ask for a little more help? I am planning on publishing the results of the query to a Report with BeginDate and EndDate. Also, the report will contain a status of where the person is; On Vacation, Sick Leave, Outside the Country, etc. Is is possible to change the background of the field on the report based on the Status (e.g., On Vacation = Green, Sick Leave = Red)? I know that I can do a bit of it via Conditional Formatting but that has a limited number of formats (I think 3 or 5). I am looking at about 6 or 7 different colour changes. Thank you.
Date manipulation as always been a pain with Access... I found this method and it works fine so...
Using A2007, you should have no problems opening the report hidden, set the date range then make it visible. Don't forget that this 'complicated' way of handling dates works independently of your date format.
Using A2007, you should have no problems opening the report hidden, set the date range then make it visible. Don't forget that this 'complicated' way of handling dates works independently of your date format.
A bit late but...
Yes there is a very easy solution: in Detail_Format use a Select Case 'AbsenceStatus'
in the Case 'N', set what ever you want like AbsenceStatus.ForeColor to the wanted color... don't forget to reset it to its initial value!!!!
Yes there is a very easy solution: in Detail_Format use a Select Case 'AbsenceStatus'
in the Case 'N', set what ever you want like AbsenceStatus.ForeColor to the wanted color... don't forget to reset it to its initial value!!!!
