Report parametwer value

[John]

I have entered the formula below in an unbound text control box in my report
header to capture begin and end date for each report being printed printed .
The formula seems to work but data input boxes now appear twice each for the
begin date and end date, and everything on the report is crammed together.
How do I correct these problems. I am using an older version of Access
(ver. 7.0).
="From " & [Enter Start Date] & " to" & [Enter End Date]

 

[John]

Correction - not everything in the report crams together. Only the report
printing of the begin and end date input by the user.

 

[Joan Wild]

Correction - not everything in the report crams together. Only the
report printing of the begin and end date input by the user.

I have entered the formula below in an unbound text control box in my
report header to capture begin and end date for each report being
printed printed . The formula seems to work but data input boxes now
appear twice each for the begin date and end date, and everything on
the report is crammed together. How do I correct these problems. I
am using an older version of Access (ver. 7.0).
="From " & [Enter Start Date] & " to" & [Enter End Date]

You are getting the prompt twice for each because the criteria in your query
is not *exactly* the same as in this textbox. The parameters must be
exact - perhaps your query has [Enter Start Date:]

As for running together, the only thing I see is that a space after the 'to'
is needed.

.... & " to " & ...
You can always add more spaces inside the quotes to spread it out more.