datasheet form size

[UsenetUser]

Access 2007. It might just be when copying the db (I'm in development
stage with it), but I adjust the form size in datasheet (design) view,
save it. Close/open it, and the size is the same. Come back a day or
two later and it is much bigger.

Thanks

 

[Jeanette Cunningham]

Hi UsenetUser,
are we talking one form or several forms.
Have you checked for code in the form which might change its size.
Have you checked the size to fit and the vertical and horizontal anchors for
any controls on the form.
Presumably you are not using tabbed forms.
Does this form open acDialog to one size, but open bigger when opened from
the nav pane?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[UsenetUser]

Hi Jeanette,

Several forms.

I am not aware of any code that can set the width of a datasheet. If
there is, I'd love to hear about it!

No, I am not in this case using a tabbed forms, and I do not open the
form in acDialog.

Anchors - to be honest, I haven't explored that, but will, but for
sure I have not changed the default settings either in code or design
mode.

Thanks!