Change Background Colour !

[Branagan]

Hi,

I'm currently using MS Access 2002.

I use forms to display client info and i would like to know if the following is possible, and if so, how ?

When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.

eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.

Kinds Regards
Chris

 

[Dennisk]

from Access 2000 onwards you have the capability of conditional formating.
Although this will only allow you to change the background of a control box.
To change the form colour you could check the dates in the forms On_Current event and set the appropriate background colour

 

[Branagan]

any help anyone ?

would this below code i found be any use ??

Between DateAdd("m", -6, Date) And Date

 

[Ron_dK]

As suggested , do a search on conditional format on this forum and
get back if any question remain.

Hth

 

[GaryPanic]

Still think my qry option would probably be a better work round

you could then have a box that if x is true then .colur red else .blue

I run something similar on something i am working on
I run a qry to update records quotes

quote with a date on it (start date) if (now) equals or is greater than then flag record as declined (with a filter to ensure that quotes taken up are excluded ) then when I load the form their is a yes/no field that is yes for declined(or expired) and this greys out area's of the quote - its visual and works (i also went down the route of traffic light options if order then green , if quote open (no order and not declined )orange and if decline red however the colour pallet wasn't up to it
as you will only need 2 colours might be an option green for go red for no

you could have a text box on your screen
properties .invisible but if x = true then visible and this could be any colour you like or even flashing- I notice on your orginal post you went down 6 month route , would you not be better doing 183 days instead ???