Conditional Formatting Between Versions

[scouser]

Has anybody had problems regards 'Conditional Formatting' between access versions?

I have an unbound control 'Order Status' and applied some conditional formatting:
[Forms]![frmOrders]![OrderClosed] = -1
' Set Fore Colour Red & Back Colour to black
[Forms]![frmOrders]![OrderClosed] = 0
Set Fore Colour to Blue Back colour to white

The control is set to display 'Open Order' upon form load new record.
This works fine on my PC at home. At work however when I select a new customer from the combo the control 'Open Order' flickers for an age and 'Calculating' appears in the bottom toolbar? It eventually stops to display the current status i.e. Order Open

To get round this on the form event 'On Current I put:
Me.OrderStatus.ForeColour = "Whatever" dependent on the condition of the control.

Just wondered if anybody else had experienced quirky problems!!
Phil

 

[sambo]

I'm experiencing this same issue. It happens when I change records on my form. The status bar reads "Calculating..." and the conditions do not take affect until I mouse-over any of the BOUND fields on my form. Very strange. Anyone know why?

 

[sambo]

Just found this .
I should have known!

 

[scouser]

Cheers

Thanks for the link.

 

[sambo]

I removed my calculation from the ControlSource and all was right with the world again.