Parameter Value

X

XeniaEagle

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
 
A

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]
 
X

XeniaEagle

Thanks Allen
I'll try that
Roger

Allen Browne said:
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.

XeniaEagle said:
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
Click to expand...
Click to expand...
 
Top