Test Prompt

  • Thread starter Thread starter acss
  • Start date Start date
A

acss

I have a report from a query which has prompts for customer id and account. I
would like to have a prompt for a text box on the top of the report yet i did
not create a field in my tables for this. What is the best way for this?
 
acss said:
I have a report from a query which has prompts for customer id and account. I
would like to have a prompt for a text box on the top of the report yet i did
not create a field in my tables for this. What is the best way for this?
Click to expand...


If you just want the user to enter something that will
appear in a report header text box, then set the text box's
control source to:

[Enter something]
or
=[Enter something]

You could also add:
DummyField: [Enter something]
as a calculated field in the report's record source query
and the report can then bind a report text box to DummyField
 
acss,
If you place an unbounded text control called Comments on the report,
with a ControlSource of...
= [Enter Comments]
You will be prompted every time you run the report for [Enter Comments].
That text you enter in response to the parameter prompt, will be displayed
in the Comments field in print and print preview.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top