Forms squashed in dialog view

[RL]

I have a form which is opened by a macro in dialog mode. The underlying table
contains several records. All the other forms which I have setup in the same
way open to a certain height, regardless of the number of records. If all
records don't fit, there is a vertical scroll bar.

This one form however, usually (but not always) displays just one of the
records so that I have to scroll down to see the rest of the list
individually.

I have tweaked all the relevant properties to their logical settings (see
below), to try to make this form behave in the same way as the others, but
have not suceeded.


Any ideas what I am doing wrong?

Default view: Continuous form
Auto Centre: Yes
Auto resize: Yes
Fit to screen: Yes
Border style: Dialog
Scroll bars: Vertical only

 

[Jeanette Cunningham]

Hi RL,
you can put code in the form's open or load event to size and move it as you
like.

Use DoCmd.MoveSize
Check out vba help on MoveSize - it is easy to do.
You will need to convert from cm or inches to twips.
In Australia ( form measurements in centimetres) I do it like this:
DoCmd.MoveSize 5.6 * 567, 9.85 * 567

the *567 converts measurements in cm to twips.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia