Access: How can I create a query with set parameter

[nesster13]

Does anybody know how I can create a set parameter in a select query?

For example: Short Desc: [Please enter a short description] on the
field of a select query will promp the user to input data. Is there a
way to set the limit to the input to like 10 characters long?

Any help is greatly appreciated.

 

[Guest]

Like "*" & Left([Please enter a short description], 10) &"*"
But this gives no prompt to the user if they entered something longer.

You could enter in a form and on update run macro with a condition checking
lenght of the input. If too long then a message to re-enter.

 

[nesster13]

Thank you very much Karl. I have tried this out and it work great.
Thanks

 

[nesster13]

Well I have used the Left([Please enter a short description], 10) and
the query run great. But when i tried to export it as a Text Files it
gave me the error of "too few parameters" do you know how to fix this?
Thanks for the help.