By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,335 Members | 2,718 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,335 IT Pros & Developers. It's quick & easy.

Field on report visible or not depending on current date

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

Aug 20 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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?
Aug 20 '06 #2

P: n/a
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.

Aug 20 '06 #3

P: n/a
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.
Aug 20 '06 #4

P: n/a
Thanks Tom, that's what I did and it works just like I needed.

Aug 26 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.