Conditional Formatting?

[unit213]

I’m completely new to Access so forgive me. I have decent Excel skills though just to give you some background.

I am working on a project that requires the cell background to turn red when specific number goes negative.

Is there any conditional format type code that can be written to do this?

 

[Joe4]

I believe you can change the color of controls on Forms and Reports, but it will have to be with VBA code. I don't believe Access has anything like Conditional Formatting.

 

[bmacr]

Actually, if you happen to use Access 2000 or newer, there is Conditional Formatting much like Excel found in the Format menu.

 

[bmacr]

If you need the code, the following should work:

In a report: (FORMAT event of the DETAIL section)

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.YourFieldName < 0 Then
Me.YourTextBox.BackColor = vbRed
Else
Me.YourTextBox.BackColor = vbWhite
End If
End Sub

or, in a form's CURRENT event: (Note, this will only work in Single Form view. Continuous forms make it much more complicated)

Private Sub Form_Current()
If Me.YourFieldName < 0 Then
Me.YourTextBox.BackColor = vbRed
Else
Me.YourTextBox.BackColor = vbWhite
End If
End Sub