How can I format color in my query

[Themba via AccessMonster.com]

When i run my query i've realised i got negative numbers.So i'd would like to
change the color for the negative numbers numbers to red.And the positive
ones should remain black.how can I do this

 

[Rick B]

In the query or in the report? You posted this to a report newsgroup.

 

[Duane Hookom]

You should really use forms whenever possible. In any case you can set the
format property of the column/text box to something like:

#,##0.00[Black];(#,##0.00)[Red];0.00;"Null"

 

[Guest]

I understand, you want the negative numbers to show up coloured in a report.

Have the report in design view and call up the code window.
The following example shows different colours at given blood pressure levels:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Select Case Me!Diastole
Case Is = "N/A"
With Me!Diastole
.ForeColor = QBColor(0)
.FontBold = False
End With

Case Is <= 90
With Me!Diastole
.ForeColor = QBColor(2)
.FontBold = True
End With

Case Else
With Me!Diastole
.ForeColor = QBColor(12)
.FontBold = True
End With

End Select

End Sub

Configure the “Select Case†to your needs.
Hope this helps.