Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
 
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.
 
Thanks so much for the expression, but can you tell me how to make the
background change to another color for days 8-15 in the month? I know I
shouldn't have put * in my form name, but at the time I wanted the form to be
at the top of the list. It's probably referenced too many time in db to
change now.

Thanks,
PHisaw

Klatuu said:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.

PHisaw said:
I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
Click to expand...
Click to expand...
 
Add a condition to your conditional formatting for the control, then:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) > 7

PHisaw said:
Thanks so much for the expression, but can you tell me how to make the
background change to another color for days 8-15 in the month? I know I
shouldn't have put * in my form name, but at the time I wanted the form to be
at the top of the list. It's probably referenced too many time in db to
change now.

Thanks,
PHisaw

Klatuu said:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.

PHisaw said:
I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
Click to expand...
Click to expand...
Click to expand...
 
I'm sorry - I don't think I explained myself well enough. I need the default
formatting to be yellow for days 1-7, #1 condition - green for days 8-15, #2
condition - blue for days 16-23 and #3 condition - pink for days 24-31.

If I use the >7, I'm not sure how to limit the condition to just the seven
days needed (8-15). I'm thinking a "between" or "greater than less than"
expression and have tried everything I know of.

Thanks again for the help!!

Klatuu said:
Add a condition to your conditional formatting for the control, then:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) > 7

PHisaw said:
Thanks so much for the expression, but can you tell me how to make the
background change to another color for days 8-15 in the month? I know I
shouldn't have put * in my form name, but at the time I wanted the form to be
at the top of the list. It's probably referenced too many time in db to
change now.

Thanks,
PHisaw

Klatuu said:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.

:

I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
Click to expand...
Click to expand...
Click to expand...
 
Yellow:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7
Green:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])
7 And
Click to expand...
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 15
Blue:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])
15 And
Click to expand...
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 23

Once you have done the above, you will find out that there are only 3
conditions allowed in conditional formatting. Arrrgh!!!!, you might say.
Never fear, there is a very easy solution:
Set the color of the control to Pink in design view. Then, if none of the
conditions avove are met ( it is after the 23rd), it will be pink.



PHisaw said:
I'm sorry - I don't think I explained myself well enough. I need the default
formatting to be yellow for days 1-7, #1 condition - green for days 8-15, #2
condition - blue for days 16-23 and #3 condition - pink for days 24-31.

If I use the >7, I'm not sure how to limit the condition to just the seven
days needed (8-15). I'm thinking a "between" or "greater than less than"
expression and have tried everything I know of.

Thanks again for the help!!

Klatuu said:
Add a condition to your conditional formatting for the control, then:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) > 7

PHisaw said:
Thanks so much for the expression, but can you tell me how to make the
background change to another color for days 8-15 in the month? I know I
shouldn't have put * in my form name, but at the time I wanted the form to be
at the top of the list. It's probably referenced too many time in db to
change now.

Thanks,
PHisaw

:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.

:

I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
Click to expand...
Click to expand...
Click to expand...
 
This worked exactly the way I wanted - thanks so much for your time and help!!

PHisaw

Klatuu said:
Yellow:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7
Green:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])
7 And
Click to expand...
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 15
Blue:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])
15 And
Click to expand...
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 23

Once you have done the above, you will find out that there are only 3
conditions allowed in conditional formatting. Arrrgh!!!!, you might say.
Never fear, there is a very easy solution:
Set the color of the control to Pink in design view. Then, if none of the
conditions avove are met ( it is after the 23rd), it will be pink.



PHisaw said:
I'm sorry - I don't think I explained myself well enough. I need the default
formatting to be yellow for days 1-7, #1 condition - green for days 8-15, #2
condition - blue for days 16-23 and #3 condition - pink for days 24-31.

If I use the >7, I'm not sure how to limit the condition to just the seven
days needed (8-15). I'm thinking a "between" or "greater than less than"
expression and have tried everything I know of.

Thanks again for the help!!

Klatuu said:
Add a condition to your conditional formatting for the control, then:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) > 7

:

Thanks so much for the expression, but can you tell me how to make the
background change to another color for days 8-15 in the month? I know I
shouldn't have put * in my form name, but at the time I wanted the form to be
at the top of the list. It's probably referenced too many time in db to
change now.

Thanks,
PHisaw

:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.

:

I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
Click to expand...
Click to expand...
Click to expand...
 
Great, happy to help

Klatuu said:
Yellow:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7
Green:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])
7 And
Click to expand...
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 15
Blue:
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])
15 And
Click to expand...
Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 23

Once you have done the above, you will find out that there are only 3
conditions allowed in conditional formatting. Arrrgh!!!!, you might say.
Never fear, there is a very easy solution:
Set the color of the control to Pink in design view. Then, if none of the
conditions avove are met ( it is after the 23rd), it will be pink.



PHisaw said:
I'm sorry - I don't think I explained myself well enough. I need the default
formatting to be yellow for days 1-7, #1 condition - green for days 8-15, #2
condition - blue for days 16-23 and #3 condition - pink for days 24-31.

If I use the >7, I'm not sure how to limit the condition to just the seven
days needed (8-15). I'm thinking a "between" or "greater than less than"
expression and have tried everything I know of.

Thanks again for the help!!

Klatuu said:
Add a condition to your conditional formatting for the control, then:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) > 7

:

Thanks so much for the expression, but can you tell me how to make the
background change to another color for days 8-15 in the month? I know I
shouldn't have put * in my form name, but at the time I wanted the form to be
at the top of the list. It's probably referenced too many time in db to
change now.

Thanks,
PHisaw

:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods]) <= 7

If the * is really part of a form name, get it out of there! It is a bad
practice to use any special character other than an underscore in any name of
any object. Ignoring this basic rule will sooner or later cause you grief.

:

I have a field that I want to use conditional formatting on based on a date
field in a subform of the same form as the field with the conditional
formatting. The main form is f*GeneralInformationWITHQUOTE and the field is
CustomerName. The subform is fStatusSubform and the date field is
ReceiptOfGoods.
I want to be able to change the background color of CustomerName if the date
shows day 1-7 of any month. Example: Yellow background for days 7/1/05,
7/2/05, 8/3/05, etc.

If I use the following in the conditonal formatting box:

Day([Forms]![f*GeneralInformationWITHQUOTE]![fStatusSubform].[Form]![ReceiptOfGoods])=1

it works fine, but if I try "1 or 2", it works for only 1. I've tried
"between# and#" and nothing works.

Any help would be greatly appreciated.

Thanks,
PHisaw
Click to expand...
Click to expand...
Click to expand...
 
Back
Top