View Full Version : Printing Date Range in a Report


DebbieV
03-24-2003, 09:17 AM
Hi All,
I am at a lost, I have created a switchboard in which you can enter in a date range for data to appear in reports. This works fine and the data for that date range that was entered in the switchboard text boxes appears on the reports but when you go to print the report, the date range will not show on the printed report. The only thing that shows is Transactions Between:
This is what I have entered in the text box in the page header;
=" Transactions Between: " & [Forms]![frmSwitchboard].[txtStartDate] & "- " & [Forms]![frmSwitchboard].[txtEndDate]

Look forward to your response

Debbie

DebbieV
03-25-2003, 11:03 AM
FYI
I figured it out. Maybe someone else might find this helpful also. I have put a command button on the switchboard to allow you to preview the report and when entering the code I selected
DoCmd.OpenReport strReport, acViewPreview, , strSQL.
So I put another command button for Print and choose
DoCmd.OpenReport strReport, acViewNormal, , strSQL.
So now I have two commands buttons one for preview and the other for print. And it works great.

Debbie