Re: Criteria formatting
From: Robin Ball (robin_at_ball-online.co.uk)
Date: 04/29/04
- Next message: Lapchien: "splitting text on a report"
- Previous message: Allen Browne: "Re: How to add a Serial no Field in Label Report?"
- In reply to: Max: "Criteria formatting"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 15:05:51 +0100
I have used a sneaky method to do this, particularly on continuous forms
where changing the property of a control affects all records on display.
Create 2 fields one has a record source such as
=IIf([AmountDue]>=1000,[AmountDue],"")
The second field has the record source =IIf([AmountDue]<1000,[AmountDue],"")
The first field can be formatted however you like, bold, red, italic
The second field can have its own format green, normal ... whatever
Once you have checked that they work as you require (the conditions can be
as complex as you like) then make sure that the 2 controls are exactly the
same size and put one exactly on top of the other.
As with any calculated control make sure that the control name is not the
same as any of the underlying field names.
Sounds clunky but works a treat.
Regards
Robin Ball
"Max" <anonymous@discussions.microsoft.com> wrote in message
news:57df01c42d46$d5aafcd0$a401280a@phx.gbl...
> Hello,
>
> 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.
>
> Any assistance on code would be greatly appreciated.
>
> Thanks
> Max
- Next message: Lapchien: "splitting text on a report"
- Previous message: Allen Browne: "Re: How to add a Serial no Field in Label Report?"
- In reply to: Max: "Criteria formatting"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
