If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting
Hi,
I have a report that shows next three and six month appointments from the first visiting. The appointment dates are different from each patient so it is hard for me to know who I will see soon. Ex: First visiting three month later six month later 1/22/09 4/24/09 7/22/09 4/30/09 7/30/09 10/30/09 5/04/09 8/04/09 01/014/10 Is there a way to format the dates( from the list above) that are close to today will have red color ? In my example, the 4/24/09 should be in red. Please help Thank you in advance Chi |
#2
|
|||
|
|||
Formatting
You should be able to use Conditional Formatting from the Format menu.
-- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi, I have a report that shows next three and six month appointments from the first visiting. The appointment dates are different from each patient so it is hard for me to know who I will see soon. Ex: First visiting three month later six month later 1/22/09 4/24/09 7/22/09 4/30/09 7/30/09 10/30/09 5/04/09 8/04/09 01/014/10 Is there a way to format the dates( from the list above) that are close to today will have red color ? In my example, the 4/24/09 should be in red. Please help Thank you in advance Chi |
#3
|
|||
|
|||
Formatting
Hi Duane,
Thank you very much for your help! Would you please show me how to write a expression that will make the dates are before or after TODAY are in red since I don't see the option for TODAY under "Field Value Is"? Thanks Chi "Duane Hookom" wrote: You should be able to use Conditional Formatting from the Format menu. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi, I have a report that shows next three and six month appointments from the first visiting. The appointment dates are different from each patient so it is hard for me to know who I will see soon. Ex: First visiting three month later six month later 1/22/09 4/24/09 7/22/09 4/30/09 7/30/09 10/30/09 5/04/09 8/04/09 01/014/10 Is there a way to format the dates( from the list above) that are close to today will have red color ? In my example, the 4/24/09 should be in red. Please help Thank you in advance Chi |
#4
|
|||
|
|||
Formatting
You can use Date() to return the current date. You can also select
"Expression Is" from the Condition drop down to reference fields other than the control you are formatting. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi Duane, Thank you very much for your help! Would you please show me how to write a expression that will make the dates are before or after TODAY are in red since I don't see the option for TODAY under "Field Value Is"? Thanks Chi "Duane Hookom" wrote: You should be able to use Conditional Formatting from the Format menu. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi, I have a report that shows next three and six month appointments from the first visiting. The appointment dates are different from each patient so it is hard for me to know who I will see soon. Ex: First visiting three month later six month later 1/22/09 4/24/09 7/22/09 4/30/09 7/30/09 10/30/09 5/04/09 8/04/09 01/014/10 Is there a way to format the dates( from the list above) that are close to today will have red color ? In my example, the 4/24/09 should be in red. Please help Thank you in advance Chi |
#5
|
|||
|
|||
Formatting
Hi Duane,
Again, Thank you so much! That is very nice option in Access! I got today date in red! However, I would like to have that the three days before and after today are in red. please help Thanks Chi "Duane Hookom" wrote: You can use Date() to return the current date. You can also select "Expression Is" from the Condition drop down to reference fields other than the control you are formatting. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi Duane, Thank you very much for your help! Would you please show me how to write a expression that will make the dates are before or after TODAY are in red since I don't see the option for TODAY under "Field Value Is"? Thanks Chi "Duane Hookom" wrote: You should be able to use Conditional Formatting from the Format menu. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi, I have a report that shows next three and six month appointments from the first visiting. The appointment dates are different from each patient so it is hard for me to know who I will see soon. Ex: First visiting three month later six month later 1/22/09 4/24/09 7/22/09 4/30/09 7/30/09 10/30/09 5/04/09 8/04/09 01/014/10 Is there a way to format the dates( from the list above) that are close to today will have red color ? In my example, the 4/24/09 should be in red. Please help Thank you in advance Chi |
#6
|
|||
|
|||
Formatting
Hi Duane,
Thank you so much for your patience and help! Finally, I got what I wanted. Chi "Duane Hookom" wrote: You can use Date() to return the current date. You can also select "Expression Is" from the Condition drop down to reference fields other than the control you are formatting. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi Duane, Thank you very much for your help! Would you please show me how to write a expression that will make the dates are before or after TODAY are in red since I don't see the option for TODAY under "Field Value Is"? Thanks Chi "Duane Hookom" wrote: You should be able to use Conditional Formatting from the Format menu. -- Duane Hookom Microsoft Access MVP "Chi" wrote: Hi, I have a report that shows next three and six month appointments from the first visiting. The appointment dates are different from each patient so it is hard for me to know who I will see soon. Ex: First visiting three month later six month later 1/22/09 4/24/09 7/22/09 4/30/09 7/30/09 10/30/09 5/04/09 8/04/09 01/014/10 Is there a way to format the dates( from the list above) that are close to today will have red color ? In my example, the 4/24/09 should be in red. Please help Thank you in advance Chi |
Thread Tools | |
Display Modes | |
|
|