Conditional formatting

  • Thread starter Thread starter Bre-x
  • Start date Start date
B

Bre-x

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


Thank you all

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

Thank you all

Bre-x
Click to expand...

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.
 
Thank you

It works very well


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

Thank you all

Bre-x
Click to expand...

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.
Click to expand...
 
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 (e-mail address removed) 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?
 
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.
 
--
Gypsymega99


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

Thank you all

Bre-x
Click to expand...

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.
Click to expand...
 
Back
Top