@anonymous: "I have a report based on a crosstab query with dates 
accross the top and entities down the side.  The values 
are dollar amouns summed from a table with two relevent 
fields:  Amount and Source.  There could be several 
records from different sources that sum to the same cross-
section of the report.
What I want to do is: Let's say there are three records 
that are summed to get the value shown in entity 1000 in 
Jan-01 in my report.  If the source field of any of those 
records is "Region", I wan the fill color of that cross-
section to be light green."
    @duanehookom: "Could you please enter a few resulting records into a message so we have a
better understanding of your query results? Then explain which
records/controls would have a different format.
Duane Hookom
MS Access MVP
news:133d701c3f72b$514e0d70$<email_address>
<quote>"
    @marshbarton: "<quote>
You're on the right track.  You do need to get the subreport
count up to the main report.
Add a hidden text box to the same section of the main report
that contains the subreport and set its control source to an
expression like this:
=IIf(subreport.Report.HasData,subreport.Report.subtextbox,0)
Then use this main report text box in your CF Expression.
Marsh
MVP [MS Access]"
    @CGo: "In office 07; I'm trying to format a field in a report.  I can change the 
color of the text depending if the order is late or due within the next 30 
days.  What I am trying to do is change the background of the due date column 
depending on what quarter it falls in.  I've tried just typing in the date 
but that doesn't seem to work. Any suggestions??
Thanks
Chris"
    @newsgroups: "CGo,
    Using Conditional Formatting against a date field named DOC...
        Month([DOC]) In (1,2,3)
    This would allow a color selection for any date within the first 
quarter.
        Month([DOC]) In (4,5,6)
    For second quarter...
        Month([DOC]) In (7,8,9)
    For third quarter
    Most folks think there are only 3 conditions allowed in conditional
formatting, but logically there are 4.
    If a Month(date) is not any of the above, use the Default Formatting
color to represent the fourth quarter.
    Also, because this is a report, you can use the OnFormat event
of your date control's report section to color the date field background.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Month(DOC) = 1 Or Month(DOC) = 2 Or Month(DOC) = 3 Then
        DOC.BackColor = QBColor(14)
    ElseIf Month(DOC) = 4 Or Month(DOC) = 5 Or Month(DOC) = 6 Then
        DOC.BackColor = QBColor(11)
    ' etc etc for all 4 quarters
    End If
End Sub
    hth
    Al Campagna
    Microsoft Access MVP
    <url>
    "Find a job that you love... and you'll never work a day in your life."
"CGo" <email_address> wrote in message 
news:<email_address>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 4, "forum_name": "microsoft.public.access.reports.20140630.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}