Input values thru unbound textboxes

[abdoudiaw]

Hi
I have a report that selects and shows records where a specified date field is within the range of 2 dates that the
user enters.
I created 2 unbound textboxes on the report with a Shortdate format and InputMask 0000-00-00;0;_.
When user enter correct dates, then everything works fine: selection is properly done, the right records show up.
But I have 2 problems:
1-the input mask is not working: the user can input anything!
2-the 2 unbound textboxes do not show the dates entered by the user.
It seems the value entered bu user does not go straight into the unbound textbox.
How do I either intercept the value entered by the user directly into the unbound textbox or via a variable?
Thanks.

 

[Solo712]

Hi
I have a report that selects and shows records where a specified date field is within the range of 2 dates that the
user enters.
I created 2 unbound textboxes on the report with a Shortdate format and InputMask 0000-00-00;0;_.
When user enter correct dates, then everything works fine: selection is properly done, the right records show up.
But I have 2 problems:
1-the input mask is not working: the user can input anything!
2-the 2 unbound textboxes do not show the dates entered by the user.
It seems the value entered bu user does not go straight into the unbound textbox.
How do I either intercept the value entered by the user directly into the unbound textbox or via a variable?
Thanks.

You can run a Before_Update event on the text box to check what has gone in.

Best,
J.