Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an input box that defines the date for analysis. It can be changed by the user to redraw the charts. How can I set the value that contains the input box on the document load to be the current date? Thanks in advance!
You mean you want the input box to show current date whenever the document is opened?
If so, then you can create a variable as suggested by Anand and write an action OnOpen of the document. Say your variable is :
vCurrent = Today()
Then write the following action,Go to Settings--Document Properties--Triggers tab, then in Document Event Triggers, add an action :
Action Type : External
Action : Set Variable
Write the variable name and the value in respective boxes.
Hope this helps!
Use a variable like vCurrent = Today() and use this variable in the input box. It always show current date value and if you have to find from any field then use peek function.
Hope this helps
Thanks & Regards
It is not convenient as I can't apply neither input constraints nor number format settings to such input box. Is there a kind of event driven solution? Like vba windows apps function for events: Onload, etc.
You mean you want the input box to show current date whenever the document is opened?
If so, then you can create a variable as suggested by Anand and write an action OnOpen of the document. Say your variable is :
vCurrent = Today()
Then write the following action,Go to Settings--Document Properties--Triggers tab, then in Document Event Triggers, add an action :
Action Type : External
Action : Set Variable
Write the variable name and the value in respective boxes.
Hope this helps!
That does work! Thanks a lot!