Parameter Query limits and format

[Gegsy]

I am a very new access 2003 user and would welcome advice on how to cause the parameter text within [xxxxx...etc]to occupy two lines ( i.e force a carriage return and line feed) and thereby reduce the width of the parameter input box that the user sees. Also are there limits to the number of characters that can be used. I seem to remember a figure of 50 but cannot find it again in any of the books I have.

Many Thanks

Gerry

 

[neileg]

Why don't you capture the parameter in a form? Much more user friendly.

You don't really want to embed CR/LF in your data, anyway.

 

[Gegsy]

Neil,

thanks for the advice, wasn't too sure of how to do what you suggested and a bit embarassed to ask. So I went searching and found an article online that gave me very detailed step by step instructions that even I could follow.
Thanks again for pointing me in another direction.

Gerry

 

[neileg]

Never be embarrased to ask in here. I knew nothing when I came across this forum, so we've all been there at some point. No one minds the simple questions, 'cos they're easy to answer!

Two tips, though. Try searching for existing questions and answers, first. Then, when you post, try and outline the fundamental problem. Sometimes people want their solution to be fixed, rather than getting a correct solution to the real issue.

Good luck!