Conditional formatting

On a Datasheet Form, can you "Conditional Format" and entiry record? (make
the row "Yellow" per example)


Thank you all

Bre-x

On Fri, 24 Oct 2008 09:35:47 -0600, Bre-x wrote:

On a Datasheet Form, can you "Conditional Format" and entiry record? (make
the row "Yellow" per example)

Thank you all

Bre-x

Make the row yellow when?
What is the criteria to make the row yellow?

Let's assume you wish to color the row if the Record's [CompanyName]
field is for "Jones Co."

Open the form in Design View.
Click on the control that will display the company name.
Click on Format + Conditional Formatting
Set Condition1 to:
Value is
in the next box select
equal
In the next box write:
"Jones Co."
Select the Yellow color.
Click OK

Next, select each of the other controls of that record.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
In the next box write
[CompanyName] = "Jones Co."
Select the color.
Click OK.

Make sure the BackStyle property for each control is set to Normal.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thank you

It works very well


"fredg" wrote in message
news
On Fri, 24 Oct 2008 09:35:47 -0600, Bre-x wrote:

On a Datasheet Form, can you "Conditional Format" and entiry record?
(make
the row "Yellow" per example)

Thank you all

Bre-x

Make the row yellow when?
What is the criteria to make the row yellow?

Let's assume you wish to color the row if the Record's [CompanyName]
field is for "Jones Co."

Open the form in Design View.
Click on the control that will display the company name.
Click on Format + Conditional Formatting
Set Condition1 to:
Value is
in the next box select
equal
In the next box write:
"Jones Co."
Select the Yellow color.
Click OK

Next, select each of the other controls of that record.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
In the next box write
[CompanyName] = "Jones Co."
Select the color.
Click OK.

Make sure the BackStyle property for each control is set to Normal.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

You might also be interested in the thread at:


http://www.microsoft.com/office/comm...2-5e2bb6284284


for doing it in a report.

Ken Sheridan
Stafford, England

"Bre-x" wrote:

On a Datasheet Form, can you "Conditional Format" and entiry record? (make
the row "Yellow" per example)


Thank you all

Bre-x

Hi Ken!
Excuse me for addressing you with no relation to this thread.
3 days ago I've posted a question with subject "Modifying Delete Button
code". Since then I kept on getting e-mails by that
the post was answered, but whenever I open the Office Discussion page "New
users", where I posted the question, I get the list where my post is the last
one - and unanswered! As if no posts were added since 23/12/08. Moreover,
when I try to post anything - it does nor appear.
I had to google on the name of my post, to find it in the
www.tech-archive.net and to find out, that it was answered by you and a few
other guys.
So I searched on Your name in the Office Discussion page and got to this
tread - which was started on 24/12/08 - misteriously I can not see it in the
normal page view (only thru the search).
So, firstly, thank You for Your reply.
Secondly - do You have any idea what is happening with me blocked from
seeing any posts in the Office Discuccion pages (any of them) posted later
then my last post? DO you see any, or You get to the posts thru
www.tech-archive.net?

"Ken Sheridan" wrote:

You might also be interested in the thread at:


http://www.microsoft.com/office/comm...2-5e2bb6284284


for doing it in a report.

Ken Sheridan
Stafford, England

"Bre-x" wrote:

On a Datasheet Form, can you "Conditional Format" and entiry record? (make
the row "Yellow" per example)


Thank you all

Bre-x

I understand that there are some problems with Microsoft's web interface at
the moment.

That's one of the reasons why so many of us prefer to use a newsgroup
reader, pointed to msnews.microsoft.com.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mishanya" wrote in message
...
Hi Ken!
Excuse me for addressing you with no relation to this thread.
3 days ago I've posted a question with subject "Modifying Delete Button
code". Since then I kept on getting e-mails by that
the post was answered, but whenever I open the Office Discussion page "New
users", where I posted the question, I get the list where my post is the
last
one - and unanswered! As if no posts were added since 23/12/08. Moreover,
when I try to post anything - it does nor appear.
I had to google on the name of my post, to find it in the
www.tech-archive.net and to find out, that it was answered by you and a
few
other guys.
So I searched on Your name in the Office Discussion page and got to this
tread - which was started on 24/12/08 - misteriously I can not see it in
the
normal page view (only thru the search).
So, firstly, thank You for Your reply.
Secondly - do You have any idea what is happening with me blocked from
seeing any posts in the Office Discuccion pages (any of them) posted later
then my last post? DO you see any, or You get to the posts thru
www.tech-archive.net?

"Ken Sheridan" wrote:

You might also be interested in the thread at:


http://www.microsoft.com/office/comm...2-5e2bb6284284


for doing it in a report.

Ken Sheridan
Stafford, England

"Bre-x" wrote:

On a Datasheet Form, can you "Conditional Format" and entiry record?
(make
the row "Yellow" per example)


Thank you all

Bre-x

--
Gypsymega99


"fredg" wrote:

On Fri, 24 Oct 2008 09:35:47 -0600, Bre-x wrote:

On a Datasheet Form, can you "Conditional Format" and entiry record? (make
the row "Yellow" per example)

Thank you all

Bre-x

Make the row yellow when?
What is the criteria to make the row yellow?

Let's assume you wish to color the row if the Record's [CompanyName]
field is for "Jones Co."

Open the form in Design View.
Click on the control that will display the company name.
Click on Format + Conditional Formatting
Set Condition1 to:
Value is
in the next box select
equal
In the next box write:
"Jones Co."
Select the Yellow color.
Click OK

Next, select each of the other controls of that record.
Click on Format + Conditional Formatting
Set Condition1 to
Expression Is
In the next box write
[CompanyName] = "Jones Co."
Select the color.
Click OK.

Make sure the BackStyle property for each control is set to Normal.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail