Conditional Formatting

[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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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!!

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

 

[Guest]

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

7 And

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

15 And

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.

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!!

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

 

[Guest]

This worked exactly the way I wanted - thanks so much for your time and help!!

PHisaw

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

7 And

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

15 And

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.

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!!

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

 

[Guest]

Great, happy to help

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

7 And

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

15 And

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.

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!!

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