Yesterday dates will be red

[Loi]

Hi,
I have a form which stores today and yesterday records.
I would like the day textbox will change to RED collor
when ever I move to yesterday records by clicking the
record selector.

For example,
There are 06/06/04 records and 06/07/04 records stored in
the form.

When I move to yesterday records which is 06/06/04, the
day value in the day text box will change to red.

Thank you
Loi

 

[Rick B]

Use conditional formatting to say if tje value of the field is <>date() then
color it red.

Rick B


Hi,
I have a form which stores today and yesterday records.
I would like the day textbox will change to RED collor
when ever I move to yesterday records by clicking the
record selector.

For example,
There are 06/06/04 records and 06/07/04 records stored in
the form.

When I move to yesterday records which is 06/06/04, the
day value in the day text box will change to red.

Thank you
Loi

 

[Graham R Seach]

I think you mean:
=Date()-1

1. Open the form in design view.
2. Select the appropriate textbox.
3. From the Format menu, select Conditional Formatting.
4. Under Condition 1, select/enter the following values:
Field Value Is Equal To Date()-1
5. Select Font/Fore Color as Red.
6. Click OK.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html