Modal Forms

[Mike]

Hi:

Does anybody know how to
get the form to come up modally and with scroll bars?


My efforts have been with the commands

DoCmd.OpenForm "Certification", acNormal, "", "", acEdit,
acNormal (get scroll bars but not modal)

DoCmd.OpenForm "Certification", acNormal, "", "",
acEdit, acDialog (is modal but no scroll bars)


Mike

 

[Cheryl Fischer]

Mike,

Will you always want to open this form in Modal View? If so, you can set
the form's Modal Property to 'Yes' and you will have scroll bars. Setting
the Popup Property to 'Yes' also allows scroll bars. (Tested in Access
2002). It *appears* that when you use the acDialog argument in the OpenForm
method that you are also setting the BorderStyle Property to Dialog, which
may be what is negating the scroll bars.

hth,