Need calendar form to display holidays

[mazza.j]

I have a calendar form that's created using VBA. I need it to display those
days that are holidays (use different color or something). Dealing with
Massachusetts, so there are 13 different legal holidays. Obviously the actual
date changes each year for some, so ideally I'd like the holidays to be
determined using code so that the user doesn't have to input the specific
dates (fewer mistakes that way).

1 New Year’s Day - January first
2 Martin Luther King Jr.'s Birthday - Third Monday in January
3 Presidents' Day - Third Monday in February
4 Evacuation Day - March 17th (Suffolk County only)
5 Patriots' Day - Third Monday in April
6 Memorial Day - Last Monday in May
7 Bunker Hill Day - June 17th (Suffolk County only)
8 Independence Day - July 4th
9 Labor Day - First Monday in September
10 Columbus Day - Second Monday in October
11 Veterans’ Day - November 11th
12 Thanksgiving Day - Customarily the fourth Thursday in November
13 Christmas Day - December 25th

 

[Douglas J. Steele]

See my June, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free from
http://www.accessmvp.com/DJSteele/SmartAccess.html