Change row color in report

[rwahdan1978]

Hi,

I have the below report and I would like to change the color of the raw that has the lastest "TheTime" filed, how to do that?



I have the code to get the last record in the table:

Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("SELECT TOP 1 * FROM Turns ORDER BY ID DESC")


MsgBox ("Last Turn: " & rs!Person & " On " & rs!TheTime)
rs.Close
Set rs = Nothing

now how to change the color of the raw with the data selected?

[June7]

AFAIK, cannot conditionally change row color.
Can use Conditional Formatting to change Backcolor of textboxes. Changing 'row' color involves a textbox sized full width of row sitting behind other controls.
Or VBA in report Detail Format event can conditionally change Backcolor of a label sized full width of row sitting behind other controls.

[Welshgasman]

I would perhaps try with a Max(TheDate) for the Person in the query, either as part of the report query source or as a separate query linked to the report query.

SELECT tblDaily.DailyDate, Max(tblDaily.CarbsCalc) AS MaxOfCarbsCalc
FROM tblDaily
GROUP BY tblDaily.DailyDate;

Then test if controls are the same value.

[moke123]

Is date and time one field in the table or two?

[rwahdan1978]

Is date and time one field in the table or two?

2 separate fields

[moke123]

I would probably use one field and if you need to display them separately you can use format(), DateValue(), or TimeValue().

https://www.techonthenet.com/access/functions/index.php

[CJ_London]

As an alternative to using conditional formatting, investigate using the detail onprint event