Hello everyone. This is my first post after being a lurker for a number of years - you guys have taught me a huge amount, so huge thanks everyone 
Now I have an issue that I can't seem to find a solution on here for and would like some advice - apologies if this question has already been answered/solved and I just didn't find it, if so if someone would be so kind as to point me at the thread I'd be grateful.
I'm trying to build a calendar-like form to show where staff are in the current month (it's a personnel database) - I.E if they're on holiday or off sick. I have a continuous form that contains 32 text boxes in the "Detail" section, and the maximum number of rows is around 10 (with the current data). The first text box is a bound name column, and the next 31 text boxes are unbound with a function I wrote to figure out where a person is for every day in the current month, which updates each text box to one of 4 values for each "day"; Null if the date is invalid (such as the text box for the 31st in November) or a weekend day, 1 if a record is found for the staff member in the holiday table, 2 if a record is found for the staff member in the sickness table, and 0 if no record is found in either table.
When I load the form, it takes between 21 and 23 seconds to load and calculate all the values (not amazing performance, but acceptable).
What I want is for all of the boxes to be blank where the values are 0, blue where the value is 1, and red where the value is 2. (Ignore weekend and invalid dates for now, I'm handling them separately - though I don't think this is causing my problem because I haven't written it in yet). To do this, I added simple conditional formatting to the 31 text boxes to change the font and fill colour to the relevant colours based on the text box value, then set the default value to a white fore colour and back colour.
My problem is that when I do this, the form takes unacceptably long to load (I stopped timing after 3 and a half minutes and crashed it out). Stranger still, after the first 20-30 seconds what I can see on the form is that it has already calculated all the values and coloured them appropriately but the VB code window still appears to be running through the code to calculate the day values - but all I've changed is to add conditional formatting! If I remove the conditional formatting, the form reverts back to only taking 20-ish seconds to load.
If anyone could help me figure out why adding CF to the form seems to be causing this I'd be very grateful.
Oh, I'm using Access 2003 by the way.

Now I have an issue that I can't seem to find a solution on here for and would like some advice - apologies if this question has already been answered/solved and I just didn't find it, if so if someone would be so kind as to point me at the thread I'd be grateful.
I'm trying to build a calendar-like form to show where staff are in the current month (it's a personnel database) - I.E if they're on holiday or off sick. I have a continuous form that contains 32 text boxes in the "Detail" section, and the maximum number of rows is around 10 (with the current data). The first text box is a bound name column, and the next 31 text boxes are unbound with a function I wrote to figure out where a person is for every day in the current month, which updates each text box to one of 4 values for each "day"; Null if the date is invalid (such as the text box for the 31st in November) or a weekend day, 1 if a record is found for the staff member in the holiday table, 2 if a record is found for the staff member in the sickness table, and 0 if no record is found in either table.
When I load the form, it takes between 21 and 23 seconds to load and calculate all the values (not amazing performance, but acceptable).
What I want is for all of the boxes to be blank where the values are 0, blue where the value is 1, and red where the value is 2. (Ignore weekend and invalid dates for now, I'm handling them separately - though I don't think this is causing my problem because I haven't written it in yet). To do this, I added simple conditional formatting to the 31 text boxes to change the font and fill colour to the relevant colours based on the text box value, then set the default value to a white fore colour and back colour.
My problem is that when I do this, the form takes unacceptably long to load (I stopped timing after 3 and a half minutes and crashed it out). Stranger still, after the first 20-30 seconds what I can see on the form is that it has already calculated all the values and coloured them appropriately but the VB code window still appears to be running through the code to calculate the day values - but all I've changed is to add conditional formatting! If I remove the conditional formatting, the form reverts back to only taking 20-ish seconds to load.
If anyone could help me figure out why adding CF to the form seems to be causing this I'd be very grateful.
Oh, I'm using Access 2003 by the way.