 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / December 2005long date
in a query, I prompt for a date range ( mm/dd/yyyy ) -- works great in a report based on the query, I want to re-display the entered date in a long-date format..... cannot figure out a way...... ( I can only get the mm/dd/yyyy displayed --- or an error ) thanks siggy Set the Format property of the textbox control that's displaying the date to Long Date.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > in a query, I prompt for a date range ( mm/dd/yyyy ) > -- works great [quoted text clipped - 5 lines] > thanks > siggy tried -- and failed > Set the Format property of the textbox control that's displaying the date > to Long Date. [quoted text clipped - 8 lines] >> thanks >> siggy "failed" doesn't give us much to go by... So, you've got a query and you've set a parameter along the lines of [Enter Date (mm/dd/yyyy)], and you're putting =[Enter Date (mm/dd/yyyy)] as the control source for a textbox on your report. Two options. With your query open in Design Mode, select Query | Parameters... from the menu bar. In the dialog that appears, type the name of your parameter exactly as entered in the query in the Parameter column, and Date/Time as the Data type. Alternatively, in your report, put =CDate([Enter Date (mm/dd/yyyy)]) as the control source SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > tried -- and failed > [quoted text clipped - 10 lines] >>> thanks >>> siggy =CDate([Enter Date]) --- and setting format to Long Date ** worked - great ----- thanks a 'bunch' > "failed" doesn't give us much to go by... > [quoted text clipped - 26 lines] >>>> thanks >>>> siggy Try this -- In query design view copy your prompt (so that it will be identical) and paste in a new column to create an output something like this -- My Date Range: CVDate([Enter the date range]) Use this output in your report and set format for the field to your long date format. > in a query, I prompt for a date range ( mm/dd/yyyy ) > -- works great [quoted text clipped - 5 lines] > thanks > siggy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.