Problem with Conditional Formating

[AccessAce]

I have a continuous form with a text box that will display one of two values.

If the value is X, make the background green.
If the value is Y, use the default Red background.

The form works great and the formatting works, unless there is only one record. If there is only one record, the Form Header and Detail section get rendered, but the Form Footer does not display until the mouse cursor moves over the text box with the conditional formating. It makes no difference if the value is X or Y, it only happens when there is only one record.

Any help or ideas would be appreciated.

 

[RiderJon]

Try this: - This one changes "red/white" to "black/white" combo. - You can change to green using its code which I am not sure right now.

' txtAgeTotal is a text-box

If (Y) Then
'fill RED/default
Me.txtAgeTotal.BackColor = "255"
Me.txtAgeTotal.ForeColor = "16777215"
Else
'UNFILL with white back + black fore.
Me.txtAgeTotal.ForeColor = "0"
Me.txtAgeTotal.BackColor = "16777215"
End If

RiderJon
"I might have created ctrl+alt+del,
But Bill made it famous" - Dr. Dave

 

[AccessAce]

I've got the switching colors to work. Any thoughts on why it seems to pause when there is only one record?

 

[CajunCenturion]

Could you post the relavent code, and indicate how that code is triggered?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein