Field on report visible or not depending on current date

[rinmanb70]

Is there a way to make a field on a report be visible or not depending
one the current date?

[Tom van Stiphout]

On 20 Aug 2006 15:11:56 -0700, "rinmanb70" <em**********@gmail.com>
wrote:

Depends what exactly you mean. Typically you would write your code in
the Report_OnFormat event. Something like:
Me.SomeField.Visible = (Me.SomeField.Value = Date())
or
Me.SomeField.Visible = (Date() = #1/1/2007#)

-Tom.

>Is there a way to make a field on a report be visible or not depending
one the current date?

[rinmanb70]

I'm sorry. I wasn't detailed enough. I want the field to be visible
if the current date is the 1st through the 14th of the month, but if
the current date is the 15th through the end of the month then I'd like
the to field not be visible.

[Tom van Stiphout]

On 20 Aug 2006 16:00:26 -0700, "rinmanb70" <em**********@gmail.com>
wrote:

You can modify my original code to suit those requirements. Remember
that the Day function extracts the day portion of a date, so you can
check if it's <= 14 or not.

-Tom.

>I'm sorry. I wasn't detailed enough. I want the field to be visible
if the current date is the 1st through the 14th of the month, but if
the current date is the 15th through the end of the month then I'd like
the to field not be visible.

[rinmanb70]

Thanks Tom, that's what I did and it works just like I needed.