Coniditonal Formatting Problem

[Costefran]

Can anyone please help with the following

I am trying to conditionally format a form text box [A] based on the results of another text box called [Clash or Not] on the same form. The [Clash or Not] text box uses a Dlookup to set ts value, which works fine

In the conditional formatting detail for text box A I have entered

Expression is [Clash or Not]="Clash" then the text box should turn red

Unfortunately text box A goes transparent (assuming the forms backcolor) when the conditionally formatting is applied (I think)
When the conditional formatting is removed text box A returns to its base colour of White

 

[TheAceMan1]

Howare ya Costefran . . .

I've simulated this in A2K with no problem. Are you sure you set the [blue]background color[/blue] in [blue]Conditional Formatting?[/blue] ... just check ...

What access version?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Costefran]

Thanks

as per my second thread

It seems if I waited long enough then it worked. Guess its simply the speed of my PC

Thanks anyway

 

[TheAceMan1]

Costefran . . .

DLookup + (Slow Speed) = Wait!

DLookup + (Slow Speed) + (Large Dataset) = Wait Much Longer!

Out of curiosity how fast is your machine?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]