Can you control siz and location of datasheet?

[jpl458]

Have some queries in command buttons just to get a quick look at stuff in a table. The datasheet is fine except I wish I could adjust is location on the screen via VBA. Is that possible? I know I can change the contents, but would to control the dimension and where it pops up on the screen.

Thanks

jpl

 

[jimlee]

Try this replacing "YourForm" with the name of your form...

Forms("YourForm").Move Left:=100, Top:=100, Width:=10000, Height:=5000

jimlad

"There's this thing called being so open-minded your brains drop out." -

 

[alvechurchdata]

You'll get even more control over position and appearance if you use a form and set the Default View to DataSheet.

Geoff Franklin

http://www.alvechurchdata.co.uk