I'm using a form where the popup box automatically comes up after I entered some criteria in my query builder. I know how to change the verbage of the text that comes up, but can I change the formatting, and the size of the box?

We're using a touchscreen, and would like things bigger and finger size. I realize a workaround could be to change screen resolution, but I'd rather change the box.

Hi,

Unfortunately, the only way to customize the parameter box is to use your own form to replace it.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Ok, thanks. As I said, it just automatically happened as a result to adding search criteria to my query builder. I'm going to take a guess that if I want my own form to come up, I would add some sort of code to the end of the criteria I already put in?

No, you don't need to add any code to the end of the criteria. Instead, you will have to "replace" the criteria with a reference to the form. For example, where you have something like this in the criteria:

Like [Enter Search Name] & "*"

You would replace it with something like this:

Like Forms!FormName.ControlName & "*"

Using the proper form and textbox names, of course.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

PS. Oh, and one other note... When using this technique, you will have to make sure the parameter form is open first and the user has entered something in it before running the query or opening the form based on the query.

This post has been edited by theDBguy: Apr 3 2012, 12:36 PM

Awesome! I'll give it a try. I think that solves another question I have relating to these boxes as well!

Sounds great!! If you do want the user to enter a different parameter while the form is still open, you can just issue a Requery command to refresh the form.

Good luck with your project.