datediff change colure

[Morten R]

I need a litle help to make a code.
Case:
When a spesific noumber of days has expierd the colure turn red in a form.

This is the way i tink it must look:

When the form load,
If [tbl_name];[date]+30<date()
And
[tbl_name];[status]= "my_status1" Or "my_status2"
set [my_formname].[my_fildname] colure red

If not
due noting


Plase, i need some help.

 

[Oldsoftboss]

Check out conditional formatting

 

[Dreamweaver]

I need a litle help to make a code.
Case:
When a spesific noumber of days has expierd the colure turn red in a form.

This is the way i tink it must look:

When the form load,
If [tbl_name];[date]+30<date()
And
[tbl_name];[status]= "my_status1" Or "my_status2"
set [my_formname].[my_fildname] colure red

If not
due noting


Plase, i need some help.

Sorry but that code looks very wrong to me is it used in a module or a dlookup, datediff ????

But if you use the search and look for posts I have made you will find the solution as was posted for me a few months back.
But what Oldsoftboss said sounds like the best solution in your case

 

[Rich]

Date is a reserved word in Access and shouldn't be used as a field name

 

[Morten R]

Hi, thanks for a adwise i wil try to find som posts with conditional formatting.

PS. the word date, is an ilustrasjon of this day date

M.