Re: Criteria formatting

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 13:45:46 -0500

Max wrote:
>I have a report that shows outstanding issues. There is a
>field that calculates the due days of an item. I would
>like to italicize the whole record/line if the days are
>positive. (+) means the item is outstanding (-) means
>there is still time left.

You need to set the property for each control in the
section.

Dim bolLate As Boolean
        bolLate = (Me.thelatefield > 0)
        Me.controlA.FontItalic = bolLate
        Me.controlB.FontItalic = bolLate
                . . .
        Me.controlN.FontItalic = bolLate 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • Criteria formatting
    ... I have a report that shows outstanding issues. ... like to italicize the whole record/line if the days are ... Any assistance on code would be greatly appreciated. ...
    (microsoft.public.access.reports)
  • UniModem.TSP (XP/SP1) missing LINE_REPLY on lineMakeCall and lineClose
    ... operation that is outstanding as it is required according to the TAPI / TSP ... "The service provider must report completion for every ... asynchronous operation. ... Microsoft MVP for TAPI / Windows SDK ...
    (microsoft.public.win32.programmer.tapi)
  • Report Sum/If Statement
    ... I want to have the sum function state "0" if the days outstanding is ... I want the report to sum the count. ...
    (microsoft.public.access.reports)
  • Re: EU admits it was wrong about biofuels.
    ... Please deal with outstanding issues on existing threads before ... Like Vince's report, which is now seriously ... overdue. ... Or publishing your maintenance schedule for your bicycle. ...
    (uk.transport)
  • Re: EU admits it was wrong about biofuels.
    ... On Jan 14, 8:32 am, Brian Whitehead ... [SNIP] ... Please deal with outstanding issues on existing threads before ... Like Vince's report, which is now seriously ...
    (uk.transport)