adding "NEW" to new records

[Frantic]

Hi,

Another simple problem I just can't seem to figure out ...

I've got this report which shows records from one of my query's. There's a date of entry added to all the records. Now, I'd like to add "NEW" or maybe some flashy little picture (if possible) to records less than one week old.

Can someone solve this ?

Thanx !

 

[jfgambit]

Add a unbound Textbox to your form and call it NewText and then add the following into the OnCurrent Event for the Form:

If Me.CreateDate > (Date - 7) Then
Me.NewText = "NEW"
Else
End If

 

[Frantic]

THX !!!