Conditional Formats on a Form

[Gary_Mc_Mahon]

Hi,

I want my form to change background colour if a particular value exists in a field.

Under the properties of the form I not sure which event would best suit this.

Any tips.

My code will go something like

If forms![frm_Account_Screen]![Acct_OnHold]= True Then
frm_Account_Screen detail section format background = 255 ' Some tips on this line would be good.
Else
Exit Sub
End If

Cheers
Gary

 

[SydneyGeek]

Hi Gary,
one way is to use the Form's Current event. Something like:

Private Sub Form_Current()
  If [City] = "Provo" Then
    Me.Detail.BackColor = 255
  Else
    Me.Detail.BackColor = 0
  End If
End Sub

That switches the background between red (for those records meeting the criteria) and black (for those not meeting them. Note; you must be using a plain form, with none of the autoformats employed. because the Autoformat images will override the colour changes.
You should also put the code in the AfterUpdate event of the control whose value triggers the format change.

Denis

 

[Gary_Mc_Mahon]

Excellent, Thanks Denis. Works perfectly!