At 10:00 PM 6/7/2008, Fred C Kopp wrote:
I like my default date format to be MM/DD/YY.
I run a routine from a button within a form that prints a form letter. Prior
to the command that prints the letter I enter a line SET DATE 'MMM+ DD, YYYY'
The letter prints fine, such as June 07, 2008.
After the letter is printed, I <F8> to the next record. The date
format remains
'MMM+ DD, YYYY' even though I have entered SET DATE MM/DD/YY
everywhere I can
think of to enter it. This includes all the obvious places: in the
oonrrol file
itself, in the AFTER REPORT GENERATED, to the ON CLOSE from the
form--no matter
what I do the next record <F8> displays dates as MMM+ DD, YYYY.
My command SET DATE MM/DD/YY is being ignored. I simply want to
restore my date
format to my chosen default format. What gives?
Fred,
You should never muck with the database default DATE settings just to PRINT
a report.
Did you know that you can use the "Display Format..." option for that exact
control to achieve your goal?
Here's how:
01. While in report designer, right-click on the specific control and select
"Display Format..." from the speed menu options.
02. Notice the following available options:
m/d/yy
d/m/yy
mm/dd/yy
dd/mm/yy
mm/dd/yyyy
dd/mm/yyyy
d-mmm-yy
dd-mmm-yy
mmmm d, yyyy
m/d
mmm-yy
mmmm-yy
dddd, mmmm dd, yyyy
03. Select the appropriate display format and click on [OK] button.
04. You may overwrite to further customize the format, if you wish.
05. Click on [Report Preview] tab to preview the actual report.
06. Save the report and close report designer.
That's all there is to it!
Have fun.
Very Best R:egards,
Razzak.
