James,
I assume that you were able to download and take a look at the demo
file.
Were you also able to see that in the demo, with my criteria that it
worked?
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
:
I tried basically the same thing. Only difference I'm using Expression
Is:
[ReminderTypeID]=1
The color doesn't show even thought the condition is met:
I have the disable first then the text color.
James,
I have created a small demo file that will show that the settings
that
I
have described worked. If you would like, just go to:
http://www.askdoctoraccess.com/DownloadPage.htm
and scroll to the bottom of the page and click the
"ConditionalFormatIssueTesting.zip" link and down load the zip file.
Then
extract the 2007 database file and take a look.
Let me know if this does not work for you. I works for me here in
testing.
If it still does not work for you then it could be some setting in
Access.
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
:
The Locked property is and has been set to yes.
James
message
James,
I again did some more testing here, this time using Access 2007.
I
even
created a new conditional definition for an new field to see that
importing
the table and the form from a 2002 database file format did not
make
a
difference.
I actually forgot to set the field to locked the first time I
tried
it
and
sure enough, the color did not set. However, if I set the fields
locked
property to Yes (not through conditional formatting but directly
from
the
controls properties dialog box) then when I tested the enabled
property
was
set to disabled (kept the cursor from allowing the selection of
the
value)
and the color was set as designed.
Make sure you have set the Locked property to Yes and try it
again.
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
:
I added a Condition and set the field to disabled (I believe
judging
from
the text into the box)
The situation is the same.
If I set it to disabled first the color doesn't change.
James
message
James,
As you state, "when a field is set to Enabled No and Locked
Yes I
am
unable
to select the text" this is the behavior as it should be.
Amazingly enough, when I tested this here, if I only have a
change
in
the
font color, then I am also able to select the value in the
text
box
when
conditional formatting is applied. For records where it is
not
applicable,
the value cannot be selected.
However, upon farther testing, I found that if you will set
the
first
condition to set the field to disabled, then set a second
condition
to
change
the color, then you cannot select the text.
I assume that the Enabled or Disabled properties are
considered
just
like
any other formatting option since it is included as on of the
options
in
the
Conditional formatting diaog box.
HTH
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
:
Why am I not able to select the contents of the field on
records
that
don't meet the Conditional Formatting criteria???
In my experience with Access when a field is set to Enabled
No
and
Locked
Yes
I am unable to select the text and the cursor stays as normal
select.
That is the point of me setting the field in that manner.
And no. The Conditional Formatting simply sets the text to
bold
and
red.
James
message
As long as the properties are set as you have described
them
you
will
be
able
to select the contents of the field.
Is your Conditional formatting susposed to be changing one
or
both
of
these
properties?
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
:
Not sure if I'm able to copy the text - irrelevant. The
field
is
set to Enabled=No Locked=Yes. I am able to select the
field
contents
if the record meets the Conditional Formatting criteria.
James
in
message
If you just set the Locked property to Yes, then any
values
in
the
control
should be able to be copied. However, if you also set
the
Enabled
property
to No then you should not be able to even get the cursor
to
go
into
the
control and certainly should not be able to copy the
value
in
the
control.
-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
:
Access 2007 sp2.
I have a continuous form populated by a reminders
tables.
I
have
4
fields on the form. 3 fields are Enabled=No Locked-Yes.
and
the
other field is an autonumber which I keep enabled and
display
as
a
hyperlink. When I click the autonumber field it opens
an
editing
form
to the corresponding record.
I also have conditional formatting for all the fields
in
the
continuous
form.
Here's where it gets odd. Since the fields are
Enabled=No
Locked=Yes
the cursor is normal select (arrow) when hovering over
the
fields
in a
record.
But, when I hover over a record that meets the
conditional
formatting
criteria
the cursor changes to text select (crosshairs?). I'm
even
able
to
select
the
text in the
field even though I have the field Enabled=No
Locked=Yes.
I copied and pasted the form for testing purposes and
removed
all
conditional
formatting and the cursor remained normal select over
all
records.
Is this normal behavior?
Thanks,
James
