Microsoft Access Help 1

[coolskater49]

i have a text box containing a date, and would like the text to change colour if the date is within the next 30 days, is there anyway i could do this??

thanks a lot.

 

[KenReay]

Hi

In the oncurrent event of the form

If Abs(DateDiff("d",MyDate,Date())) > 30 Then
MyDAte.ForeColor = colorvalueyouwant
Else
MyDate.ForeColor = othercoloryouwant
End if

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[coolskater49]

thanks a lot, that was just what i needed.
cheers,
paul.