Box size for parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed several reports that prompt the user for information based on
a Parameter query. EG. [Enter name of Suburb EG: Mirr* will list the suburb
Mirrabooka]. The problem that some of the Parameter text is cut off. Is
there any way to increase the size of the Dialogue Box that appears when the
Parameter query is run?
Thanks for any help
 
Roger, I think you have outgrown the Parameter box.

Use a form where the user can enter all the information at once. In your
query, you can refer to Text0 on Form1 by putting an expression such as this
in the Criteria row:
[Forms].[Form1].[Text0]

Or, you might prefer to build the criteria dynamically, and apply it as the
Filter of a form, or the WhereCondition of OpenReport. If that interests you
and you understand a little VBA code, download this example:
http://allenbrowne.com/unlinked/Search2000.zip
Requires Access 2000 or later.
 
Back
Top