parameter prompt size

[Stew]

Here's a dumb little problem for you:

I've set a parameter to ask the user for a start date and an end date. The prompt I want to display is a bit long (Enter Start date for account maturity ex:m/d/y) but I think its needed to prevent error. However, the parameter prompt won't re-size automatically to show the entire message. I don't want to design a form to ask for and retrieve a simple date parameter. Can I change the size of the default parameter prompt or set it to automatically re-size? Enlighten me please.

Paul

 

[Jack Cowley]

Why not create a little form with two unbound fields and as long a description as you need. Also put a command button on the form to run the query. In the query put code like this in the criteria field of the date field:

Between [Forms]![YourFormName]![StartDateField] And [Forms]![YourFormName]![EndDateField]

 

[Stew]

Deep down I knew I would have to design a form to handle the situation. I was mostly curious about whether I could change the size of the input box (such things would make life easier). Just one of those little things that eat away at you until you know the answer.

Paul