parameter query problem

[Liz_I3]

HI
I have created a parameter query, when it runs the dialog box gives the user the Message " Please key in a region (i.e. Toronto, London, Hamiltion etc). The problems is the whole message is not displayed it is cut off after the London. Is there a way to word wrap the message or are you limited to a certain number of characters?

Thanks
Liz

 

[Ziggy]

Liz, try a different approach.

Filter by Form:

Create a form with a text box, now put the name of that text box in the criteria of your query like this:

eg.

Form!YourFormName!YourTextboxName


Now put a button on your form that opens that query. Or the report bound to the query.


Alternatvely put a combo on the form that looks up the value from your table to eliminate spelling errors. When placing the combo with the wizard choose the 1st option and store the value for later use.

Ziggy