setting size of query window

[papa jonah]

Is there a way to dictate how large a window will be when a query is
run? I have tried resizing and closing the query but to no avail. I
get these huge windows that go clear off the screen for a query result
of 1 row and 5 fields with 10 characters each.

Thanks for any suggestions.

 

[Rick Brandt]

Is there a way to dictate how large a window will be when a query is
run? I have tried resizing and closing the query but to no avail. I
get these huge windows that go clear off the screen for a query result
of 1 row and 5 fields with 10 characters each.

Thanks for any suggestions.

Open query in datasheet view, position and size as desired, change to design
view, make some kind of meaningless design change (move a table around or
similar), and then close the window and choose yes when prompted to save the
design.

The next time you open in datasheet view your size and position should be
remembered.

(this does not work for tables, only queries)

 

[papa jonah]

Thank you very much Rick! That has been buggin me for a long time!