Office 2007 Reports Parameter Promt calculating?

[QuimaxW]

I have a database that we created in office 2003 that is (basically) a
database of labels. It contains LOTS of reports all based off the same
set of 4-5 queries.

Most of these reports contain a text box similar to ="Model: " &
[Enter Model]" or =Trim("Model: " & [Enter Model]) Because this field
isn't defined in the query, it prompts the user for input, then puts
that input into the report. This is what we *want*.

With Office 2007, it seems like it's trying to calculate something
based on the input. For example, if I put "HVR 2-16 x 500G" for [Enter
Model] above, the output in the report is "Model: 5636168". If I put
in simply "123456" it ouputs "Model: 3276849"

The same database opens and works fine with Office 2003. Any ideas?

 

[Dale Fye]

Have you defined your parameter [Enter Model] in your query?

If not, right click in the top of the query grid (outside the all the
tables) and select the "Parameters" option.

Then enter "[Enter Model]" in the Parameter column and Text in the DataType
column. This will add a line that looks something like the following to the
beginning of your query:

PARAMETERS [Enter Model] Text ( 255 );



--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[QuimaxW]

Have you defined your parameter [Enter Model] in your query?

If not, right click in the top of the query grid (outside the all the
tables) and select the "Parameters" option.

Then enter "[Enter Model]" in the Parameter column and Text in the DataType
column.  This will add a line that looks something like the following to the
beginning of your query:

PARAMETERS [Enter Model] Text ( 255 );

If I define the parameter in the query, it works. I am hoping there is
an easier solution, otherwise I have around 200 parameters to plug
into the query for all the reports. It's frustrating, cause it works
fine with Access 2003 as it is.