Steven-
No can do. You can force the dialog box to accept only values that can be
interpreted as date/time by adding:
PARAMETERS [Enter Reporting Date:] Date;
.. to the front of the SQL in your query.
If you want to control the format / input mask, use a parameter form and
reference it as:
[Forms][frmEnterDate]![txtDate]
You can use the Open event of the report to open the form. Put an OK button on
the form that just hides it so the report query can find the parameter.
(Me.Visible = False) In the Close event of the Report, close the parameter
form.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of S and M
Sent: Monday, May 23, 2011 4:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Date format input mask in query
Hey everyone,
I have a report based on a query that ask for a report date like this,...
WHERE (((qryEventRevenueWithMemberName.RegDate)=[Enter Reporting Date:]));
When the dialog box pops up to enter the date, it requires that you type in the
/ marks. I would like this to automatically show the / marks just like it does
in date fields in forms when you set the input mask to short date.
I set the input mask for the criteria in the query but that did not fix it.
What am I missing?
Thanks, Steven
Access 2003 on XP
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar