Parameter Dialog box

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

Guest

Is there a way to make the "Enter Parameter Dialog Box" bigger to show all
texts in the criteria box?
[Enter 5 digits Serial Numbers separated by comma no space]
 
Is there a way to make the "Enter Parameter Dialog Box" bigger to show all
texts in the criteria box?
[Enter 5 digits Serial Numbers separated by comma no space]
Click to expand...

That works for me as well as text even triple that amount.
 
No, there is no way to do that.

If you really need to do so, then you can use a form.

You'll need to create a small unbound Form (let's call it
frmCriteria) with a control (txtCrit) on it. And a label, that you fill in with
your text prompt.

Save this form.

Now use

=[Forms]![frmCriteria]![txtCrit]

as the criterion in your Query in place of the

[Enter 5 digits Serial Numbers separated by comma no space]

Open the form, enter the number.


It's convenient to base a second Form or Report on the resulting
query to display the results; if you put a button on frmCriteria
to launch that form or report, the user can enter the criterion
and view the results in one simple operation! You can also open
the query from a button on the form.
 
Back
Top