Printing Dates on reports

[Fie]

Hi,

I have sent you a report so that when the user types in a date range
into a form it
produces results in the report relating to that data range. I have
code at the top
of the report so the date is displayed as a header so you know the
date range of the report.
So for the start date i have
=[Forms].[frmWhatDates].[txtStartDate]

and for the finish date i have

=[Forms].[frmWhatDates].[txtEndDate]

when i print out the report the dates arnt displyed. Does anyone know
why this is?
it just says on the report #Name?

Fie x

 

[John Spencer]

First thing I would try would be to use the "!" separator instead of the "."
separator

=[Forms]![frmWhatDates]![txtStartDate]

and

=[Forms]![frmWhatDates]![txtEndDate]

Next is what type of control are you using - label or textbox? I normally
use a textbox and set its control source as above.

If you are using a label then the caption property would be used.

Do you get an error when you run your report? Do you get a prompt to enter
the dates?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Fie]

Hi,

Yeah Iv used txted boxes and entered the code you suggested. I have
set up forms that pop up and ask for start date and end date when you
open the report. The dates are entered into this form and is used to
give a report between the two dates entered! When I entered the code
you suggested this still did not print out the date, when you preview
the report it shows the date

Fie

First thing I would try would be to use the "!" separator instead of the "."
separator

=[Forms]![frmWhatDates]![txtStartDate]

and

=[Forms]![frmWhatDates]![txtEndDate]

Next is what type of control are you using - label or textbox? I normally
use a textbox and set its control source as above.

If you are using a label then the caption property would be used.

Do you get an error when you run your report? Do you get a prompt to enter
the dates?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

Hi,

I have sent you a report so that when the user types in a date range
into a form it
produces results in the report relating to that data range. I have
code at the top
of the report so the date is displayed as a header so you know the
date range of the report.
So for the start date i have
=[Forms].[frmWhatDates].[txtStartDate]

and for the finish date i have

=[Forms].[frmWhatDates].[txtEndDate]

when i print out the report the dates arnt displyed. Does anyone know
why this is?
it just says on the report #Name?

Fie x