Debbie
delam at zyterra.com
Fri Sep 10 10:24:57 CDT 2010
I have a report in access 2007 that has a calendar that works nicely. My issue is when the tasks that fill my calendar fill more than a page. I am left with info at the top of the page and no date since the dates themseves are detail records. I am trying to put a date on the top of this page with one of two methods, but I am running into issues. 1. Put dates in the page header and only reveal them when the detail exceeds the page length. A: I have gotten pretty far with this one, but cannot seem to get the visible property to fire in the right spot. My code seems to be firing on the right pages, but not producing the correct results. Page 1 always has the extra dates when it should never have them and subsequent pages never have the dates even when I tell it if me.page = one page after a long detail is detected. I can see that the code fires, but no extra date is visible. 2. Make the top row of dates invisible and leave the page header dates visible all the time. A: I have not figured out how to find out if the date is printing on that first line. Any ides on the stopping points for either of these ideas, or totally new solutions are appreciated. Debbie Sent from my iPhone