Set Value Macro

[Guest]

Hi All,

I am trying to write a macro that displays a text box only for one week
during a given month. So I have the item line saying:
[Forms]![Menu]![Textbox].[Visible] but I really don't know what to put in the
expression line. I would like to write something like this: Date() >
##/10/#### AND < ##/20/####

I don't think this syntax will work. Any suggestions?

Thanks!

 

[Steve Schapel]

Rob,

If the Item argument is:
[Forms]![Menu]![Textbox].[Visible]
.... then the Expression argument can only be either :
Yes
.... or:
No

These are the only two possible values for the Visible property of the
control.

Do you mean that you want the control to be visible only if the current
date is between the 11th and 19th of the month? If so, you would use
the Condition of the SetValue macro to manage this, rather than trying
to write it into the action arguments. If you can't see the Condition
column in the macro design window, select it from the View menu. Then,
you can put like this:
Day(Date()) Between 11 And 19
.... or:
Day(Date())>10 And Day(Date())<20