Report parametwer value

J

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]
 
J

John

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

Joan Wild

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

John said:
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]
Click to expand...
Click to expand...

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.
 
Top