I make use of the DataReport from VB6. The datasource is a ADODB recordset.
The DataReport has 31 RptTextBoxes on one line.
The recorset has a variable nummer of records.
Now the question, how can I accomplish that some cells are getting a different color, according to the value thats in it.
I'll attempt to set the DataReport.RptTextBoxes.ForeColor at the moment I fill the recordset, but this doesn't work because the next record (next line on the report) will have the same color even the value isn't one that requeirs changing colors.
This is what I do:
Aaaa.Fields("Prestatie" & i) = adoPrinten.Fields(4) 'setup the recordset
If Aaaa.Fields("Uren")) <> "DA" Then
DataReport2.Sections("section1").Controls("prest" & i).ForeColor = vbRed '
Is there no other way to read each "cell" from the report after it is completed and change the color of that "cell"
Please some advice