Conditional Formats Confounded Locked/Enabled Properties

[Access User]

I have a field in a sub-form called 'Aneurism' which is a number field. When
it's values are between 1 and 3, then I conditionally formatted the color of
the bckgrnd to be greeen, taking a red when it's > 3.

When I had initially set the field's props in form view, I set enabled=No
and locked=Yes.

I find that now that the CF is on the field, the field can be entered and
the value changed :-(

Someone suggested that the 'enabled' button to the right of things when
using the CF fieature be selected. I did, but while it freezes the user from
entering the field, it also turns it a grey bckgrnd.

Why is this happening, or more to the point, how do we get around it?

 

[Stephen Lebans]

You must have multiposted instead of crossposted this question. I just
answered you 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.

 

[Access User]

As an aside can you differentiate between multi and cross-posting?

 

[Stephen Lebans]

Multiposting is posting individual messages to individual NG's. Cross
posting is posting one message to multiple NG's at one time. For people who
freely give their time to answer questions in the NG's, there is nothing
more annoying than multiposted questions. Why, because you give your time to
answer the poster in one NG only to find it already has been answered in
another NG. With cross posting, there is only one thread, visible in its
entirety from every NG it has bene posted to. Much more efficient for
everyone involved.

As a rule, I will not answer a post I that has been mulitposted. If the user
does this repeatedly then I will simply set my NG reader to ignore all of
their posts.

--

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

 

[Access User]

I think you kind of left anyone posing the same question hanging there
though, didn't you. I never said I needed to know how to tackle the task of
doing one over the other, but I would've thought that given the fact the
difference between the two was invited that the way to do each would've
seemed like a great way to wrap up your answer.

 

[Stephen Lebans]

You know, I have tried to help you several times over the last few days.
First you multiposted. Then you told me you could not find the Conditional
Formatting sample on my site(hint, it is named Conditional Formatting). Then
when I point you directly to the Conditional Formatting page you then tell
me that I am not paying attention to your request as that MDB does not seem
to contain the exact example you need. You did not bother to open the source
MDB and look at the code which shows you how to programmatically manipulate
the FormatConditions object to bypass the Enabled bug.
..
Finally, you are now telling me that I did not do a very good job of
explaining multiposting.

Obviously, my level of service does not meet your expectations. I'm done
trying to help you.
PLONK!

--

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