Parameter Value

[Guest]

I have a query which uses the
Between [Enter Start Date] and [Enter End Date]
it works great, but, when I open the query
The parameter value box will not use the input mask
_ _/__/_ _ I have to enter the forward slash.
It works in the forms, but not in reports or query's
How can I get the mask to work in the parameter value box
Thanks for any help
Roger

 

[Allen Browne]

The parameter box is not powerful enough to do that.

You could create your own form, with 2 text boxes.
Then in the query, enter something like this in the Criteria:
Between [Forms].[Form1].[StartDate] and [Forms].[Form1].[EndDate]

 

[Guest]

Thanks Allen
I'll try that
Roger

The parameter box is not powerful enough to do that.

You could create your own form, with 2 text boxes.
Then in the query, enter something like this in the Criteria:
Between [Forms].[Form1].[StartDate] and [Forms].[Form1].[EndDate]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a query which uses the
Between [Enter Start Date] and [Enter End Date]
it works great, but, when I open the query
The parameter value box will not use the input mask
_ _/__/_ _ I have to enter the forward slash.
It works in the forms, but not in reports or query's
How can I get the mask to work in the parameter value box
Thanks for any help
Roger