Conditional Formatting

D

DS

How do I set in Code...
If a field = 0 then the text is white and what event do i place it in?
Thanks
DS
 
W

Wayne Morgan

If you are using Access 2000 or newer, it would be better to use the
Conditional Formatting property of the control on the form or report. Open
the form or report in Design View, right click the control, and choose
Conditional Formatting.
 
D

DS

Wayne said:
If you are using Access 2000 or newer, it would be better to use the
Conditional Formatting property of the control on the form or report. Open
the form or report in Design View, right click the control, and choose
Conditional Formatting.
Click to expand...
The Problem with Conditional formatting that I have is whenever the
field is set to Enabled=No and Locked=Yes and TabStop is No the courser
still goes in the field, I don't want that to happen. Anyway around this?
Thanks
DS
 
W

Wayne Morgan

I just tried it and do NOT get that response. The cursor skips the field for
me. Could there be some code that is changing the 3 properties you mention?
 
S

Stephen Lebans

It is a known bug in A2K and A2K2. What version of Access are you
running Wayne?

The OP multiposted so I answered in another NG.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
S

Stephen Lebans

I did not realize this bug was finally fixed in A2003. I will do some
testing this weekend.
:)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
D

DS

Stephen said:
I did not realize this bug was finally fixed in A2003. I will do some
testing this weekend.
:)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
Click to expand...
Any chance of getting that bug fixed in 2002 or 2000? It's causing me
terrible problems!!!
Thanks
DS
 
S

Stephen Lebans

The bug fix is to programmatically modify the FormatConditions object
directly bypassing the CF GUI. Sample code is on my site.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Top