How to size query windown when opening.

T

ThomasAJ

I have quite a number of queries that I use for gathering 'quick' info and do
not want to feed them into reports/forms.

Can I 'lock in' a query window size when opening. I have adjusted the size
(in design and open modes) t hen saved but they revert to an original size.
For that matter how was the 'original' size locked in in the first place?
 
M

MGFoster

ThomasAJ said:
I have quite a number of queries that I use for gathering 'quick' info and do
not want to feed them into reports/forms.

Can I 'lock in' a query window size when opening. I have adjusted the size
(in design and open modes) t hen saved but they revert to an original size.
For that matter how was the 'original' size locked in in the first place?
Click to expand...

This works for me:

Open the query in design view.
Change something (delete a letter and then type it back in)
Size the query window to the size you want.
Run the query.
Close the query.

When you re-open the query it is the size you made it.
 
J

John Spencer

Dear Tom,

I just tried it with Access 2000 and it worked for me. I must admit I had
never noticed this before; and I decided to test and see. I was even able
to just open the query in normal view, resize it, and then save it. I then
closed the query and opened it again. It remembered the new sizing.

I haven't tested it with other versions of Access.
 
Top