Conditional formatting changes field enabled property?

I have a subform control with continuous forms as its default view. I have
the fields on the subform set to .Enabled = False and .Locked = True as I
want to be able to scroll up and down the records but not to be able to
change any data. The records where the conditional formatting conditions
apply appear to have the .Enabled property set to True allowing the cursor to
enter the field.
Does anyone know about this problem?

Richard,

In addition to font, type weight, background color, etc., you can also set
the Enabled property for records meeting the specified condition, which
overrides the Enabled status set in form view.

Open the form in form view, click on the control, select Format, Conditional
Formatting, and click the Enabled button at the far right to disable.

Hope that helps.
Sprinks


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I have
the fields on the subform set to .Enabled = False and .Locked = True as I
want to be able to scroll up and down the records but not to be able to
change any data. The records where the conditional formatting conditions
apply appear to have the .Enabled property set to True allowing the cursor to
enter the field.
Does anyone know about this problem?

Check if yu have any cde on the on current event of the form that might set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I have
the fields on the subform set to .Enabled = False and .Locked = True as I
want to be able to scroll up and down the records but not to be able to
change any data. The records where the conditional formatting conditions
apply appear to have the .Enabled property set to True allowing the cursor to
enter the field.
Does anyone know about this problem?

I think Sprinks is right, I tried it, but the problem that the format had
changed.
It showed the fields as gray.


--
\\// Live Long and Prosper \\//
BS"D


"Ofer" wrote:

Check if yu have any cde on the on current event of the form that might set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I have
the fields on the subform set to .Enabled = False and .Locked = True as I
want to be able to scroll up and down the records but not to be able to
change any data. The records where the conditional formatting conditions
apply appear to have the .Enabled property set to True allowing the cursor to
enter the field.
Does anyone know about this problem?

Many Thanks Sprinks, and Ofer.
I didn't recognise that when the fields in the Conditional Formatting window
turned grey, it meant that the enabled property of the field was disabled.
Problem solved.

"Sprinks" wrote:

Richard,

In addition to font, type weight, background color, etc., you can also set
the Enabled property for records meeting the specified condition, which
overrides the Enabled status set in form view.

Open the form in form view, click on the control, select Format, Conditional
Formatting, and click the Enabled button at the far right to disable.

Hope that helps.
Sprinks


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I have
the fields on the subform set to .Enabled = False and .Locked = True as I
want to be able to scroll up and down the records but not to be able to
change any data. The records where the conditional formatting conditions
apply appear to have the .Enabled property set to True allowing the cursor to
enter the field.
Does anyone know about this problem?

I'm getting the same behavior.....I want the "Aneurism" field to be coded
with a green color when it's between 1 and 3 and to take a red background
when it's gt 3. I have set the field to be enabled=no and locked=yes in the
'data' properties of the 'Aneurism' control's in the sub-form where it sits
and it does change colors when I test it before I read this response. I
noticed that in addition to changing colors per the conditional formatting
that it loses it's 'protected' status once I invoked the conditional
formatting, however, unless I'm wrong, clicking the 'enable' button in your
emails had the effect of graying it out. I'm perplexed.

"Ofer" wrote:

I think Sprinks is right, I tried it, but the problem that the format had
changed.
It showed the fields as gray.


--
\\// Live Long and Prosper \\//
BS"D


"Ofer" wrote:

Check if yu have any cde on the on current event of the form that might set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I have
the fields on the subform set to .Enabled = False and .Locked = True as I
want to be able to scroll up and down the records but not to be able to
change any data. The records where the conditional formatting conditions
apply appear to have the .Enabled property set to True allowing the cursor to
enter the field.
Does anyone know about this problem?

If I remember correctly, in some versions of Access, the Enabled property is
not respected when you set it via the Conditional Formatting UI. You need to
programmatically set the FormatConditions object to work around this Bug.
There is sample code on my site showing you how to do this.

--

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


"Access User" wrote in message
...
I'm getting the same behavior.....I want the "Aneurism" field to be coded
with a green color when it's between 1 and 3 and to take a red background
when it's gt 3. I have set the field to be enabled=no and locked=yes in
the
'data' properties of the 'Aneurism' control's in the sub-form where it
sits
and it does change colors when I test it before I read this response. I
noticed that in addition to changing colors per the conditional formatting
that it loses it's 'protected' status once I invoked the conditional
formatting, however, unless I'm wrong, clicking the 'enable' button in
your
emails had the effect of graying it out. I'm perplexed.

"Ofer" wrote:

I think Sprinks is right, I tried it, but the problem that the format had
changed.
It showed the fields as gray.


--
\\// Live Long and Prosper \\//
BS"D


"Ofer" wrote:

Check if yu have any cde on the on current event of the form that might
set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I
have
the fields on the subform set to .Enabled = False and .Locked = True
as I
want to be able to scroll up and down the records but not to be able
to
change any data. The records where the conditional formatting
conditions
apply appear to have the .Enabled property set to True allowing the
cursor to
enter the field.
Does anyone know about this problem?

That sounds like it could be really useful, but your website's a little
overwhelming, can you please give me a few more details wrt which resource
you're meaning?

"Stephen Lebans" wrote:

If I remember correctly, in some versions of Access, the Enabled property is
not respected when you set it via the Conditional Formatting UI. You need to
programmatically set the FormatConditions object to work around this Bug.
There is sample code on my site showing you how to do this.

--

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


"Access User" wrote in message
...
I'm getting the same behavior.....I want the "Aneurism" field to be coded
with a green color when it's between 1 and 3 and to take a red background
when it's gt 3. I have set the field to be enabled=no and locked=yes in
the
'data' properties of the 'Aneurism' control's in the sub-form where it
sits
and it does change colors when I test it before I read this response. I
noticed that in addition to changing colors per the conditional formatting
that it loses it's 'protected' status once I invoked the conditional
formatting, however, unless I'm wrong, clicking the 'enable' button in
your
emails had the effect of graying it out. I'm perplexed.

"Ofer" wrote:

I think Sprinks is right, I tried it, but the problem that the format had
changed.
It showed the fields as gray.


--
\\// Live Long and Prosper \\//
BS"D


"Ofer" wrote:

Check if yu have any cde on the on current event of the form that might
set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default view. I
have
the fields on the subform set to .Enabled = False and .Locked = True
as I
want to be able to scroll up and down the records but not to be able
to
change any data. The records where the conditional formatting
conditions
apply appear to have the .Enabled property set to True allowing the
cursor to
enter the field.
Does anyone know about this problem?

http://www.lebans.com/conditionalformatting.htm

--

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


"Access User" wrote in message
...
That sounds like it could be really useful, but your website's a little
overwhelming, can you please give me a few more details wrt which resource
you're meaning?

"Stephen Lebans" wrote:

If I remember correctly, in some versions of Access, the Enabled property
is
not respected when you set it via the Conditional Formatting UI. You need
to
programmatically set the FormatConditions object to work around this Bug.
There is sample code on my site showing you how to do this.

--

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


"Access User" wrote in message
...
I'm getting the same behavior.....I want the "Aneurism" field to be
coded
with a green color when it's between 1 and 3 and to take a red
background
when it's gt 3. I have set the field to be enabled=no and locked=yes in
the
'data' properties of the 'Aneurism' control's in the sub-form where it
sits
and it does change colors when I test it before I read this response. I
noticed that in addition to changing colors per the conditional
formatting
that it loses it's 'protected' status once I invoked the conditional
formatting, however, unless I'm wrong, clicking the 'enable' button in
your
emails had the effect of graying it out. I'm perplexed.

"Ofer" wrote:

I think Sprinks is right, I tried it, but the problem that the format
had
changed.
It showed the fields as gray.


--
\\// Live Long and Prosper \\//
BS"D


"Ofer" wrote:

Check if yu have any cde on the on current event of the form that
might
set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default
view. I
have
the fields on the subform set to .Enabled = False and .Locked =
True
as I
want to be able to scroll up and down the records but not to be
able
to
change any data. The records where the conditional formatting
conditions
apply appear to have the .Enabled property set to True allowing
the
cursor to
enter the field.
Does anyone know about this problem?

Thanks, but I don't think it's what I'm needing at the moment based on the
description

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet View

Recall, that when I apply a conditional format to a text control on my
sub-form so as to vary the color depending on the numerical value entered
(1-3 = green, gt 3 = red), that the enabled=no and locked=yes properties get
trashed.

Thx.

"Stephen Lebans" wrote:

http://www.lebans.com/conditionalformatting.htm

--

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


"Access User" wrote in message
...
That sounds like it could be really useful, but your website's a little
overwhelming, can you please give me a few more details wrt which resource
you're meaning?

"Stephen Lebans" wrote:

If I remember correctly, in some versions of Access, the Enabled property
is
not respected when you set it via the Conditional Formatting UI. You need
to
programmatically set the FormatConditions object to work around this Bug.
There is sample code on my site showing you how to do this.

--

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


"Access User" wrote in message
...
I'm getting the same behavior.....I want the "Aneurism" field to be
coded
with a green color when it's between 1 and 3 and to take a red
background
when it's gt 3. I have set the field to be enabled=no and locked=yes in
the
'data' properties of the 'Aneurism' control's in the sub-form where it
sits
and it does change colors when I test it before I read this response. I
noticed that in addition to changing colors per the conditional
formatting
that it loses it's 'protected' status once I invoked the conditional
formatting, however, unless I'm wrong, clicking the 'enable' button in
your
emails had the effect of graying it out. I'm perplexed.

"Ofer" wrote:

I think Sprinks is right, I tried it, but the problem that the format
had
changed.
It showed the fields as gray.


--
\\// Live Long and Prosper \\//
BS"D


"Ofer" wrote:

Check if yu have any cde on the on current event of the form that
might
set
the property of the field to enabled = yes

--
\\// Live Long and Prosper \\//
BS"D


"Richard Corner" wrote:

I have a subform control with continuous forms as its default
view. I
have
the fields on the subform set to .Enabled = False and .Locked =
True
as I
want to be able to scroll up and down the records but not to be
able
to
change any data. The records where the conditional formatting
conditions
apply appear to have the .Enabled property set to True allowing
the
cursor to
enter the field.
Does anyone know about this problem?