Access calender, ignore weekends and bank holidays

[philtr]

I'm using access 2007 and have some date fields in my forms, i'd like to be able to blank out weekends and public holidays from the calender/date selector in these fields so theres no way those dates can be selected. Is this possible? Thanks.

 

[ajetrumpet]

Instead of doing that, I would just issue a message to the user if they happen to select one of these lucky dates. You can use the DLOOKUP function to query the date that they have entered, and issue the warning if the date falls on a weekend day or holiday.