Colours on a report

[DC CS]

I have a report with some data and is bound to a query.


The report consists of the months and some calculated values under each month.

The month headings contain the names of the month. Depending on criteria, I want the label containing the month name, to display a background color (Cyan). I use RGB(0, 255, 255). The code I use, as follows:

    If Me("Label" & i).Caption = MonthName(i) And Month(TmpRptDate) < Month(Date) Then
        Me("Label" & i).Caption = Me("Label" & i).Caption & " " & Format(Date, "yyyy") + 1
        Me("Label" & i).BackColor = RGB(0, 255, 255)
    ElseIf Me("Label" & i).Caption = MonthName(i) And Month(TmpRptDate) >= Month(Date) Then
        Me("Label" & i).Caption = Me("Label" & i).Caption & " " & Format(Date, "yyyy")
    End If

everything is fine, except that only the first label background is changed to Cyan. All the other labels that meet the first criteria, the backcolor stays white and is no changed. See picture below of the report. (All the months with |"2025" should be Cyan):



Any suggestions?

Thanks

[Welshgasman]

Not showing much code there are you?

Is that code within a loop incrementing i ?
Are the labels all called Label1, Label2 etc?

Walk your code with F8 and breakpoints and inspect the variables.

[DC CS]

Hi Welshgasman,
Yes, the code is within a For...Next loop.
Label captions are named Label1, Label2...Label12

I did step through the code with F8 and every time it executes the change of the color, but when the report is displayed, only the first label (Label1) has changed color to Cyan.

I also tried running the code in the Detail_Format event as well as the PageHeaderSection_Format event, but with the same result.

[Welshgasman]

Out of ideas then, sorry.
You could post the DB with enough to see the problem. I work best like that for silly stuff.
By that, I mean stuff that *should* work, but does not. Generally it is a silly error causing it.

[A S MANN]

If you run code in On load event than it will run partially
Place code in On Format of report .

[DC CS]

Hi,
It seems the solution is to NOT use labels on the report. I replaced the labels with text boxes and now the ones that need to be a different back color, has indeed changed color.

Thanks

[Welshgasman]

Hi,
It seems the solution is to NOT use labels on the report. I replaced the labels with text boxes and now the ones that need to be a different back color, has indeed changed color.

Thanks

Hmm, strange
Well done for finding a solution.