Share via

Input mask for a parameter prompt

Anonymous
2013-03-08T23:32:55+00:00

In forms I can use a input mask when entering a date.   Is there a way that I can use a input mask for a query prompt?  This would make it easier for the user when entering a date.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2013-03-09T00:58:11+00:00

Queries run directly can prompt for criteria by putting [ ] around the criteria text like [Enter beginning Date?].  You can go to the query parameters and set the data type.  But there is no way to create a input mask to control the data entry as you can on a form.

Personally, I would use a form to gather the criteria and then launch the query using the forms fields as criteria.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful