I have two fields named,
BeginningDate and EndingDate on my form called ReportSelection

and then in my report in the report's pageheader i have a text field whose control source is set as follows,

="(Between " & Format([Forms]![ReportSelection]!BeginningDate,"m/d/yyyy") & " and " & Format([Forms]![ReportSelection]!endingdate,"m/d/yyyy") & ")"


AS i said the display onscreen shows ,
(Between 1/1/2007 and 10/28/2007)


but when i print the report i get,
(Between 12/31/1999 and 12/31/1999)

I hope this helps you understand my problem better.
Thanks for your help