I need to open a form as a modal dialog so im using the following code:

DoCmd.OpenForm "Ducali_DataEntry", acNormal, , , , acDialog

However when I do this the form no longer has the vertical slider which I
have to have. If I remove the acDialog attribute the form no longer opens
modally and the code doesnt pause. Any suggestions? Thanks in advance

Normal behavior. Workaround is to put a subform on the form, and use the
subform to show the data; the subform will show its vertical scrollbar if
enabled.

--

Ken Snell
<MS ACCESS MVP>

"RHC" <(E-Mail Removed)> wrote in message
news:28C17771-6EAF-479F-A7F6-(E-Mail Removed)...
>I need to open a form as a modal dialog so im using the following code:
>
> DoCmd.OpenForm "Ducali_DataEntry", acNormal, , , , acDialog
>
> However when I do this the form no longer has the vertical slider which I
> have to have. If I remove the acDialog attribute the form no longer opens
> modally and the code doesnt pause. Any suggestions? Thanks in advance