Specify size of datasheet form

[CW]

I have about 30 forms in use, all of which are set to open maximised as
they're all quite busy and we need the full size view to see everything. Most
of them are in Single Form view, but a few are Continuous.
Now I want to have a popup Datasheet form that overlays the currently opened
form, but I want it to be only about half the screen width and about 3 inches
high, and centred both vertically and horizontally.
I have set it to AutoResize = No and Autocentre = Yes and have tried
resizing the form whilst in Form view, but as soon as I close and re-open it,
it comes back maximised.
Is it because every other form is maximised so I am not going to be able to
achieve this?
Can I put some code in the OnCurrent or OnLoad event(s) to dictate the size
and position, and if so, what? Or if not this, how do I get what I want?
Many thanks
CW

 

[tina]

i tested this setup in an A2000 db running in A2003, and was successful with
the following:

kept the "open maximized" code on the "first" form.
set the following properties on the popup form:

AutoResize = Yes
AutoCenter = Yes
PopUp = Yes
BorderStyle = Thin

and in the OnLoad event procedure, adding code, as

DoCmd.Restore

i set the form's size by opening the form in Design view and clicking the
Restore Window button at the right side of the Title bar, then dragging the
edges of the form to the size i wanted, then *saving* and closing from
Design view. you could probably set the height and width from code, perhaps
in the Open or Load event, but i've never tried it.

hth

 

[CW]

Hey Tina that's great - worked immediately - I appreciate it VERY MUCH!
Thanks
CW

 

[CW]

Oops - further to previous reply... actually there's a problem, I cannot
resize it to accommodate all the fields (datasheet columns) that I want
displayed. I have to use the horizontal scroll bar to see the hidden columns.
Don't want that, I want all columns to be fully visible. It insists on being
a fixed size no matter what I do in either Design View or Form View. If I
alter the width in Properties, that makes no difference either. Something
somewhere is locking the width.... what, and how?
Thanks
CW

 

[tina]

beats me, hon, i didn't have any trouble changing the size as i described
previously. perhaps i wasn't clear though: i opened the form in Design
view, clicked the Restore Window button at the right side of the Title bar,
then dragged the edges of the *window* - not the gray design space within
the window - to the size i wanted, then saved in Design view, and closed.

hth