Parameter Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]
 
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...
 
Back
Top