Making some fields visible and others not...

[Shannon3778]

I've got a report with multiple date fields. I only want the fields that have todays date in them to be visible but with the code I've written, all of the data in the field disappears even if it does have today's date... here's an example of the code I'm using
Private Sub Report_Load()
If [Week 1] = today Then
Me.[Week 1].Visible = True

Else
Me.[Week 1].Visible = False

I've also tried using date() instead of today but get the same result. I'm sure this must be an easy fix but I just can't figure it out. help??? Please??

 

[PaulO]

Worth checking, in the underlying data Table, exactly how the Date is being formatted and stored. Other than than, try Conditional Formatting of the Field in the Report, rather than Code?