Conditional formatting

Topic

New Reply

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Replies

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

Hello:

I would like to create a conditional format for a database that I created, In the column titled “response” I created a “check box” when checked I would like the row to be highlighted yellow, is this at all possible? If yes, could someone be so kind to assist me.

Company Name, First Name, Last Name, Job Title, Address, Suite, City, Province, Postal Code, Work Number, Fax Number, Email, Website, Employees, Response, Date of Contact,

Thank you,

Nottingham

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

I am using access 2002

Thank you,

Notts

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

Reply | Quote

What version of Access are you using?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

Where do you wish to highlight the row, on a form or report?

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

You can use Conditional formatting on either a form or report

The Condition would be

Response=True

Then choose the colour

However, you cannot colour the Background of the Detail Band using Conditional Formatting, only the field background.

IF you wanted to colour the background yellow the only way would be to
run code on the On Format Event of the detail band
BUT this would only work on a report because on a tabular form all rows would go yellow or white
depending upon which row you clicked in.

The code would be

Code:

If response = true then
	detail.backcolor=vbyellow
else
	detail.backcolor=vbwhite
end if

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

It does have the effect, but my point was that you cannot use the On Current Event in the same way that you can
use On Format in Reports.

Hans Solution uses a textbox (field type) control enabled and locked and quite a lot
of code running in the background.

However taking Hans Disabled, Locked Text box concept.

You could just put one big unbound textbox over the whole detail band.
Set it to be At the back.
Then place the other data controls (transparent) on top.

Finally put Conditional Formatting on the Rear Unbound Control
For Response = True Yellow otherwise Same Colour as background (cannot be Transparent)

See My Attached Example

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Andrew is right with respect to reports, but you can do something similar in forms.
Check out this sample database provided by Hans many moons ago.
This should give you some ideas.

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

Hello AndrewKKWalker, Pat, Genii:

First, I have a table, not a report or a form; could my highlight request still work with the info provided by Hans. In the “Response” column, I have set this column up a check box. “IF” I check the box in the response column, then it should highlight that particular connecting row. Is this possible?

Andrew, I took a look at Hans sample, that is exactly what I have created, but when checked, I need to show a specific colour.

In Excel I have the following in the conditional format =$L42=1, =$L42=2, =$L42=3 this small formula allows me to change the rows into 3 different colours; depending on the outcome from perspective clients.

I do not believe that the above formula can be recreated in Access.

Thank you so much for your help everyone

dillon65/Nottingham

Reply | Quote

You cannot apply conditional formatting to Tables and Query Datasheets.

Only to Forms and Reports.

Reply | Quote

Hello Andrew:

At this point then, I should just import the table into an existing spreadsheet. Thanks to all who responded.

Dillon

Reply | Quote