Start of new month = different formatting

[neillovell]

Hi,
My report has the dates of the year and what project was worked on during that day. It also has the hours worked.

I'd like to make the first day of the month stand out, as so many dates on the page will not look good. I did use conditional formatting to make it so if the date field was equal to #01/01/02# it looked different, and repeated for #01/02/02# and #01/03/02# but then there's a problem - I can only have 3 options for conditional formatting. Also, if the first of the month falls on a saturday nobody workes, so when they do work on the 3rd it does not stand out.

any thoughts?

 

[KenReay]

Hi

Instead of testing for specific dates, use a user function which returns true of false fir first day of month,

Pass the actual date to the function, extract the month from the date passed (Month(datDate)), and the Weekday() function to determine if the first day of the month is a Sat/Sun, and return true/false

regards

Ken Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[neillovell]

How do I get into coding VBA in Access? Do I have to right click the report and select it from there or what?

v.new to VBA

 

[KenReay]

Hi

With the report in design view, click view\Code from menu, or click 'Code' icon on the tool bar

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[MichaelRed]

W/o knowing the overall use and structure of your data and report, advice can be (is) only vaguely generic. I might use a groupby Month(the date field) and include a header specifying the month and a few other pertinent details, Just add some formatting effects to the group header. Saves the (awful) effort of actually learning to use Ms. A.
as well as -in my opinion- make a more 'PROFESSIONAL' looking report,

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[neillovell]

MichaelRed -
I've tried group on MONTH in design view's sorting and grouping, but I still get everything on the same page. The records for jan and feb are together still. What's going wrong?

 

[neillovell]

got it - I've put the header and footer in and it's fixed.

nice!