PARAMETERS statment in the query

[elena]

Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?

Thank you,

 

[Dale Fye]

Not in a parameter query. However, the preferred way to get data to plug
into a query is to create your own form, which you do have much more control
over.

HTH
Dale

 

[fredg]

Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?

Thank you,

You have no control over the size/appearance of the parameter dialog
box.

If you want something custom, create your own form. You can add as
many or as few features as you wish. You can have it appear anywhere
in the window you wish.

You would then refer to the form in the query criteria as:
forms!FormName!ControlName

Of course, the form must be open when the query is run.

 

[John W. Vinson]

Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?

You don't have a lot of choice with the builtin parameter box. What you can do
instead is use an unbound Form for the purpose, and a parameter like

=[Forms]![frmCriteria]![controlname]


John W. Vinson [MVP]

 

[elena]

Thank you,
It is very helpful!

Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?

You don't have a lot of choice with the builtin parameter box. What you can do
instead is use an unbound Form for the purpose, and a parameter like

=[Forms]![frmCriteria]![controlname]


John W. Vinson [MVP]