Parameter Dialog box

[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]

 

[fredg]

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]

That works for me as well as text even triple that amount.

 

[John Spencer (MVP)]

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.