Re: alternating color

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Candor Feg wrote:
> How to accomplish?
> Based on odd or even value in a field.
> thanks

In the format event of the section...

If Me!FieldName mod 2 = 0 Then
Me.Section(n).BackColor = vbGreen
Else
Me.Section(n).BackColor = vbWhite
End If

You will have to replace the 'n' with the appropriate index value for the
section. For the detail section it would be zero.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: alternating color
    ... > Candor Feg wrote: ... >> How to accomplish? ... >> Based on odd or even value in a field. ... > In the format event of the section... ...
    (microsoft.public.access.reports)
  • Re: More Of The Joys Of Old Age
    ... >>the best time to accomplish stuff, ... >>asleep, the phone doesn't ring and no one thinks ... >>about in fuzzy slippers might attract some odd ...
    (soc.culture.scottish)
  • Re: Surgery is better than cataract prevention
    ... Odd, Charles. ... I'm quite sure that I know a HELL of a lot more about ... you're chiming in in an effort to accomplish the EXACT ... Otis has pushed it to the verge of extinction. ...
    (sci.med.vision)
  • Re: Page numbering
    ... A Next Page section break does *not* insert a blank sheet unless it is accompanied by a page break. ... An Odd Page break will insert a blank even page if the previous section ends on an odd page. ... But, as pointed out in answer to another of your questions, you are inserting section breaks unnecessarily because using "Different odd and even" would accomplish what you want. ... > Footer: Odd page Footer - Section 1 ...
    (microsoft.public.word.pagelayout)