Somehow inform the user

[vagelisr]

Hi to all.

I hope to find again over here a clever answer in my problem.

I have a form in detail view.
I'm trying to find a way to inform the user which record the date is older than Current Date.
My first thought was to change the font color to red in those records, the date is older than today but I dont think it is easy to access.

Any other ideas??

Thanks and regards!!!

 

[speakers_86]

Check out conditional formatting.

 

[vagelisr]

Check out conditional formatting.

You can get more specific;;

 

[John Big Booty]

What speakers_86 is suggesting is to use Conditional Formatting to change the colour of the date if it is older that today's date.

 

[vagelisr]

Thanks Thanks Thanks.......

Finally it is very easy to do it!!!!!!!!!!!

Thanks you all of you!!!!!!!!

Problem Solved

PS-Is there any way to change the color in the other fields????

 

[speakers_86]

You can get more specific;;

 

[John Big Booty]

You could use something along the lines of;

Dim i As Integer

If Me.YourDateField < Date() Then

  For i = 0 To Me.Count - 1
      If TypeOf Me(i) Is TextBox Then
          Me(i).BackColor = vbRed
      End If
   Next i
   
Else
   For i = 0 To Me.Count - 1
      If TypeOf Me(i) Is TextBox Then
          Me(i).BackColor = vbWhite
      End If
   Next i
End If

You could put it in the form's On Current Event as well as the date field's After Update event.

 

[speakers_86]

And me.count is the count of records? I did not know it could be gotten that way.

 

[John Big Booty]

And me.count is the count of records? I did not know it could be gotten that way.

Yep lifted the code from here