Specify the query result window size

[TJAC]

One department in our company was recently upgraded to 2003, in the database
they use there is a query that prompts them for a value and then displays the
result. They are saying this query result window now appears much bigger
than it did with 2002. They don't know Access well enough to change the size
themselves. I tried to go into design view and make the window size the
correct size and then save it, but that did not work. I know how to do it in
a form, but I've never had a request like this for a query result window.

Thanks in advance.

 

[John W. Vinson]

I know how to do it in
a form, but I've never had a request like this for a query result window.

A Form's a much better (and more controllable) way to display query
results than a query datasheet in any case. I'd suggest basing a Form
on the query, and opening the Form rather than opening the query.

I *THINK* you can open the query datasheet; resize it; save it; and
that it should honor the new size, but since I rarely use datasheets
(and never for data presentation) I'm not sure how well it will work.

John W. Vinson [MVP]