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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query In Report Title 3
Creating an update query that uses multiple parameters 2
More than one label for X axis 1
Custom Parameter Dialogs for Reports 2
Reference controls on a dialogue form as the parameters 1
parameter prompt problem 2
Crosstab Graph Report not showing Parameters in text box 3
Parameter Query in Report Header 1

Back
Top