Conditional Formatting based on a character in a field

[Guest]

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Al Campagna]

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

What if I want to BOLD and ITALIC everything on the same line and before the
"*" (* is the indicator)?

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Al Campagna]

Sara,
If you mean a line "of fields", each field on the line will have to have it's own
Conditional Formatting.
(Using the same expression I suggested, but with whatever formatting you want to apply
to them)
You wrote...

and before the "*" (* is the indicator)?

I don't understand what you mean by that. Show a line of fields as they are now, and
how you want them to look if one of those fields has an "S" in it.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

What if I want to BOLD and ITALIC everything on the same line and before the
"*" (* is the indicator)?

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Guest]

I have a text box that is for comments. In this text box, I want to format
only those items that are new. So I've indicated that they are new by adding
an "*" to the end. Now I want to BOLD and Italic those "New" items. Is there
a way I can add a Right() function tot he string so that it will BOLD and
Italic everything to the Right of the "*" until it hits a line break OR hard
return?
Example: (this is something that would be in the comment box)

Test 1 - 80%
Test 2 - 90%
Test 3 – 100%* (This would be the line that I would want BOLD and Italic)

Thanks
Sara

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Guest]

I have a text box that is for comments. In this text box, I want to format
only those items that are new. So I've indicated that they are new by adding
an "*" to the end. Now I want to BOLD and Italic those "New" items. Is there
a way I can add a Right() function tot he string so that it will BOLD and
Italic everything to the Right of the "*" until it hits a line break OR hard
return?
Example: (this is something that would be in the comment box)

Test 1 - 80%
Test 2 - 90%
Test 3 – 100%* (This would be the line that I would want BOLD and Italic)

Thanks
Sara

Sara,
If you mean a line "of fields", each field on the line will have to have it's own
Conditional Formatting.
(Using the same expression I suggested, but with whatever formatting you want to apply
to them)
You wrote...

and before the "*" (* is the indicator)?

I don't understand what you mean by that. Show a line of fields as they are now, and
how you want them to look if one of those fields has an "S" in it.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

What if I want to BOLD and ITALIC everything on the same line and before the
"*" (* is the indicator)?

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Al Campagna]

Sara,
Just adjust my original conditional format for the *...
Expression Is InStr([YourFieldName],"*")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I have a text box that is for comments. In this text box, I want to format
only those items that are new. So I've indicated that they are new by adding
an "*" to the end. Now I want to BOLD and Italic those "New" items. Is there
a way I can add a Right() function tot he string so that it will BOLD and
Italic everything to the Right of the "*" until it hits a line break OR hard
return?
Example: (this is something that would be in the comment box)

Test 1 - 80%
Test 2 - 90%
Test 3 - 100%* (This would be the line that I would want BOLD and Italic)

Thanks
Sara

Sara,
If you mean a line "of fields", each field on the line will have to have it's own
Conditional Formatting.
(Using the same expression I suggested, but with whatever formatting you want to
apply
to them)
You wrote...

and before the "*" (* is the indicator)?

I don't understand what you mean by that. Show a line of fields as they are now,
and
how you want them to look if one of those fields has an "S" in it.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

What if I want to BOLD and ITALIC everything on the same line and before the
"*" (* is the indicator)?

:

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Guest]

Can you Right() Function to a Hard Return or Line Break? If so, how would
that look
Right(Instr([Comments],"*")<>0),?

Sara,
Just adjust my original conditional format for the *...
Expression Is InStr([YourFieldName],"*")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I have a text box that is for comments. In this text box, I want to format
only those items that are new. So I've indicated that they are new by adding
an "*" to the end. Now I want to BOLD and Italic those "New" items. Is there
a way I can add a Right() function tot he string so that it will BOLD and
Italic everything to the Right of the "*" until it hits a line break OR hard
return?
Example: (this is something that would be in the comment box)

Test 1 - 80%
Test 2 - 90%
Test 3 - 100%* (This would be the line that I would want BOLD and Italic)

Thanks
Sara

Sara,
If you mean a line "of fields", each field on the line will have to have it's own
Conditional Formatting.
(Using the same expression I suggested, but with whatever formatting you want to
apply
to them)
You wrote...
and before the "*" (* is the indicator)?
I don't understand what you mean by that. Show a line of fields as they are now,
and
how you want them to look if one of those fields has an "S" in it.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."


What if I want to BOLD and ITALIC everything on the same line and before the
"*" (* is the indicator)?

:

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara

 

[Al Campagna]

Sara,

Can you Right() Function to a Hard Return or Line Break?

I have no idea what you mean by that... what Hard Return... what Line Break?
As far as I know, we're discussing parsing a string value for the existence of a "*" in
the string...

Expression Is Right([Comments],1) = "*"
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

Can you Right() Function to a Hard Return or Line Break? If so, how would
that look
Right(Instr([Comments],"*")<>0),?

Sara,
Just adjust my original conditional format for the *...
Expression Is InStr([YourFieldName],"*")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I have a text box that is for comments. In this text box, I want to format
only those items that are new. So I've indicated that they are new by adding
an "*" to the end. Now I want to BOLD and Italic those "New" items. Is there
a way I can add a Right() function tot he string so that it will BOLD and
Italic everything to the Right of the "*" until it hits a line break OR hard
return?
Example: (this is something that would be in the comment box)

Test 1 - 80%
Test 2 - 90%
Test 3 - 100%* (This would be the line that I would want BOLD and Italic)

Thanks
Sara


:

Sara,
If you mean a line "of fields", each field on the line will have to have it's own
Conditional Formatting.
(Using the same expression I suggested, but with whatever formatting you want to
apply
to them)
You wrote...
and before the "*" (* is the indicator)?
I don't understand what you mean by that. Show a line of fields as they are
now,
and
how you want them to look if one of those fields has an "S" in it.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."


What if I want to BOLD and ITALIC everything on the same line and before the
"*" (* is the indicator)?

:

Sara,
You should be able to use a string function to do that....
If you looking for an "S" in any string...
Expression Is InStr([LastName],"S")<>0

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

I want to format the text in a comment field if the comment field contains a
specific character indicating that the comment is NEW. Is this possible?

Sara