I have created a series of Parameter Queries in a db (Access 2003), using the
square brackets [ ] to fill - in a Criteria. How can I specify the maximum
number of characters allowed in the fill-in box, for example we have state as
two characters, MD, PA, Ca in the tables and wish to limit the characters in
the fill-in box to match the field size.
Thanks
Paul
Conan Kelly - 15 Feb 2008 21:05 GMT
PA,
You can't.
Your only option for that (and a much better way to go) is to create a form.
Put a textbox on the form. Set the appropriat properties on the form to
limit the number of characters. I would also put a button on your form that
will run/open your query. Then change the criteria in your query to point
to the form instead of asking for input. You would do that by changing your
parameter [prompt text that was entered] to [Forms]![FormName].[TextBoxName]
(I think that syntax is correct...I can never remember the placementes of
the !'s and .'s...this would need to be verified if you want to use this
method). You don't need to put a button on the form to run the query but it
helps. Although the form does need to be open when the query is run/opened.
You can program the button to hide the form so it is not in front of your
data,
Another option would be to put a list/combo box on your form and have its
source be a table/query of all possible values (or type in all possible
values into the appropriate properties). Then it is just a matter of
selecting the option you want from the list and clicking the button to run
the query.
HTH,
Conan
>I have created a series of Parameter Queries in a db (Access 2003), using
>the
[quoted text clipped - 8 lines]
> Thanks
> Paul
Duane Hookom - 15 Feb 2008 21:14 GMT
http://www.tek-tips.com/faqs.cfm?fid=6763

Signature
Duane Hookom
Microsoft Access MVP
> PA,
>
[quoted text clipped - 35 lines]
> > Thanks
> > Paul
Conan Kelly - 15 Feb 2008 21:46 GMT
Ahhh....
Grassy-a.s, Seen-yor Hookom
> http://www.tek-tips.com/faqs.cfm?fid=6763
>
[quoted text clipped - 48 lines]
>> > Thanks
>> > Paul
PA - 16 Feb 2008 12:47 GMT
Ahhh....
Grassy-a.s, Seen-yor Hookom y Seen-yor Kelly
> Ahhh....
>
[quoted text clipped - 52 lines]
> >> > Thanks
> >> > Paul
Conan Kelly - 18 Feb 2008 17:28 GMT
Da nada.
Glad to help.
> Ahhh....
>
[quoted text clipped - 66 lines]
>> >> > Thanks
>> >> > Paul