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
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.
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
The Problem with Conditional formatting that I have is whenever theWayne said:
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?
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.
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.
W
Wayne Morgan
Thanks Stephen. I hadn't run across that one before. I'm using 2003.
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.
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
Any chance of getting that bug fixed in 2002 or 2000? It's causing meStephen 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.
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.
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.