0
Reply

Flashing Graphic if condition is true

nicole febrio

nicole febrio

Feb 5 2012 2:19 AM
1.7k
Good day,

Sir i am using ms access 2007, I want a help regarding how to code.

This is my code in a query: under [ExpiredDate] field:
<=DateAdd("m",24,Date())


under [Remarks] field: 
"Remarks: IIf(Date()>=[ExpiredDate],"To Be Renew","Unexpired")".

This all works fine and results value return. Before i am using "To Be Renew" if the condition is true. My problem is i want "To Be Renew" to change to a graphic flashing with a name of "flash.gif"

Sir how can i place the graphic as part of the button when the condition is true? Can you please help me what's the code i suppose to put. I am really new in this program.Thank you very much