Alternate rows using bold font

  • Thread starter Thread starter *Glen*
  • Start date Start date
G

*Glen*

Can anyone tell me how to make the rows in my detail section of the report
alternate between bold font and normal font to make the report easier to
read? Thanks!

Glen
 
Can anyone tell me how to make the rows in my detail section of the report
alternate between bold font and normal font to make the report easier to
read? Thanks!

Glen
Click to expand...

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), crosspost by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.
 
Glen,
Usually that's done by using an alternating light shaded background
for the entire row. This would be the Access equivalent look of "graybar"
paper used in wide 15" mainframe system printouts.
I believe Ver 2007 has an alternate shading function available in report
design.
On my website below, I have a 97 and 2003 sample file called
Alternate Shading Rows that shows how to do that for earlier Access
versions.
If you must use Bold/UnBold, you should be able to rework that code to
accomplish that.

Note: In order to cut down ink costs, I now shade every 3rd line, or
even
4th line. That saves on ink, and still makes wide reports "readable." In
that
method... in whatever appropriate report section... I start a counter, and
use the
Mod operator to determine every 3rd or 4th line to shade.
Aircode:
If LineCount Mod 3 = Then do shading
Else No Shading
or
If LineCount Mod 4 = Then do shading
Else No shading
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top