Conditional Format for Report

[CarlaInJax]

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.
What am I doing wrong?

 

[Marshall Barton]

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.

Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[CarlaInJax]

I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.

Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[Marshall Barton]

That's odd, it worked fine when I tried it (A2003)
--
Marsh
MVP [MS Access]

I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.

Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[CarlaInJax]

I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

That's odd, it worked fine when I tried it (A2003)
--
Marsh
MVP [MS Access]

I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

CarlaInJax wrote:

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.


Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[Marshall Barton]

Are you sure they had exactly the word "scheduled" in them?

Is there any kind of pattern to the ones that were not red?
E.g. at the beginning, end or way out is a very long field.
--
Marsh
MVP [MS Access]

I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

That's odd, it worked fine when I tried it (A2003)

I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

:

CarlaInJax wrote:

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.


Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[CarlaInJax]

Yes, that's what is crazy. Two entries had EXACTLY the same text in the
field. One turned red, one did not. There did not seem to be a pattern to
those that did turn red or those that did not.

Are you sure they had exactly the word "scheduled" in them?

Is there any kind of pattern to the ones that were not red?
E.g. at the beginning, end or way out is a very long field.
--
Marsh
MVP [MS Access]

I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

That's odd, it worked fine when I tried it (A2003)


CarlaInJax wrote:
I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

:

CarlaInJax wrote:

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.


Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[Marshall Barton]

I can't explain it. My tests all work fine.

When you say "exactly", does that mean that you used
Copy/Paste from one entry to the other?
--
Marsh
MVP [MS Access]

Yes, that's what is crazy. Two entries had EXACTLY the same text in the
field. One turned red, one did not. There did not seem to be a pattern to
those that did turn red or those that did not.

Are you sure they had exactly the word "scheduled" in them?

Is there any kind of pattern to the ones that were not red?
E.g. at the beginning, end or way out is a very long field.

I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

:
That's odd, it worked fine when I tried it (A2003)


CarlaInJax wrote:
I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

:

CarlaInJax wrote:

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.


Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[CarlaInJax]

No, each was a separate entry from the table. The just used the same phrasing.

I can't explain it. My tests all work fine.

When you say "exactly", does that mean that you used
Copy/Paste from one entry to the other?
--
Marsh
MVP [MS Access]

Yes, that's what is crazy. Two entries had EXACTLY the same text in the
field. One turned red, one did not. There did not seem to be a pattern to
those that did turn red or those that did not.

Are you sure they had exactly the word "scheduled" in them?

Is there any kind of pattern to the ones that were not red?
E.g. at the beginning, end or way out is a very long field.


CarlaInJax wrote:
I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

:
That's odd, it worked fine when I tried it (A2003)


CarlaInJax wrote:
I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"

:

CarlaInJax wrote:

I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.


Try setting the expression to:

[Comments/Entries] Like "*scheduled*"

 

[Marshall Barton]

If they were typed separately, they is a small chance that
there is a difference between them. Try reentering the
word.

I'm just guessing here because I don't see the same
behavior. I suppose there is some chance that Access has
not had enough time (or lost track of its screen painting).
I think(?) you can check this by minimizing Access and the
restoring it.
--
Marsh
MVP [MS Access]

No, each was a separate entry from the table. The just used the same phrasing.

I can't explain it. My tests all work fine.

When you say "exactly", does that mean that you used
Copy/Paste from one entry to the other?

Yes, that's what is crazy. Two entries had EXACTLY the same text in the
field. One turned red, one did not. There did not seem to be a pattern to
those that did turn red or those that did not.

:

Are you sure they had exactly the word "scheduled" in them?

Is there any kind of pattern to the ones that were not red?
E.g. at the beginning, end or way out is a very long field.


CarlaInJax wrote:
I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

:
That's odd, it worked fine when I tried it (A2003)


CarlaInJax wrote:
I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"


:
Try setting the expression to:

[Comments/Entries] Like "*scheduled*"


CarlaInJax wrote:
I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.

 

[CarlaInJax]

I'll try that when I return from vacation!!

Thank you so much for all of your help with this crazy problem.

Carla

If they were typed separately, they is a small chance that
there is a difference between them. Try reentering the
word.

I'm just guessing here because I don't see the same
behavior. I suppose there is some chance that Access has
not had enough time (or lost track of its screen painting).
I think(?) you can check this by minimizing Access and the
restoring it.
--
Marsh
MVP [MS Access]

No, each was a separate entry from the table. The just used the same phrasing.

I can't explain it. My tests all work fine.

When you say "exactly", does that mean that you used
Copy/Paste from one entry to the other?


CarlaInJax wrote:
Yes, that's what is crazy. Two entries had EXACTLY the same text in the
field. One turned red, one did not. There did not seem to be a pattern to
those that did turn red or those that did not.

:

Are you sure they had exactly the word "scheduled" in them?

Is there any kind of pattern to the ones that were not red?
E.g. at the beginning, end or way out is a very long field.


CarlaInJax wrote:
I also have 2003. I'm stumped. When I run my report seven entries meet the
conditional requirements, but only three entries have red text.

:
That's odd, it worked fine when I tried it (A2003)


CarlaInJax wrote:
I've tried that and I get an error message that tells me "The expression you
entered contains invalid syntax"


:
Try setting the expression to:

[Comments/Entries] Like "*scheduled*"


CarlaInJax wrote:
I am trying to use conditional formatting to have Access seach for certain
words within a field. My field name is Comments/Entries and I would like for
the field to be shown in RED if the phrase "Repair scheduled" or "scheduled"
is anywhere within the text of this field. I set conditional formatting
using expression to Expression Is and then typed "repair scheduled",
"scheduled".
Sometimes this works and some of the fields are shown in red, and sometimes
it does not and the fields displaying this phrase or word are still shown in
black.