How can I format color in my query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Themba - 13 Dec 2005 09:28 GMT

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

Reply to this Message

Rick B - 13 Dec 2005 14:32 GMT

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

Signature

Rick B

> 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

Reply to this Message

Duane Hookom - 13 Dec 2005 14:53 GMT

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"

Signature

Duane Hookom
MS Access MVP
--

Reply to this Message

bernie - 17 Jan 2006 20:26 GMT

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.

> 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

Reply to this Message