Date Format: Preview & Print Differences

  • Thread starter Thread starter Paanwa
  • Start date Start date
P

Paanwa

Quick question:
Why would the appearance of a date change from report preview to the actual
printout of the report?

I have a sub that changes the formatting of a date for some languages. For
non-English dates I rip apart the date and create a string - which appears
correctly in preview, but reverts back to US date formatting. But like I
said, it is a string (cstr() and all)!

I have tested against a brand new textbox that has no mask, no format, no
control source...

I am using Access XP on an XP Pro machine.

Any ideas?
 
I am not quite sure however, what you may check is that
the textbox is not named for one of your variables. maybe
that causes the problem.
Hope this helps.
Fons
 
I have a sub that changes the formatting of a date for some languages. For
non-English dates I rip apart the date and create a string - which appears
correctly in preview, but reverts back to US date formatting. But like I
said, it is a string (cstr() and all)!
Click to expand...

I found a solution to this problem. I was making this formatting changes in
the Detail OnFormat event but moved my code to the Report OnActivate event.
The preview and printout are now consistant.
 
Back
Top