Why does Alt-Return bring up properties sheet?

[deko]

I have "Allow Design Changes" set to "Design View Only" in the property
sheet for my subform datasheet. But when I have my cursor in a textbox and
press Alt+Return, the property sheet for the textbox comes up.

I've discovered I can prevent this behavior by not pressing Alt+Return.

Is there any other way to prevent the property sheet from coming up? What
property will prevent this?

[Wayne Morgan]

I did some testing on this to make sure. If the Parent form is set to allow
changes in "All Views", the subform will do as you mention, regardless of
the setting you have in the subform. When a form is opened as a subform, it
is actually an object of the parent form. Some settings still work
independently, but apparently, this isn't one of them.

--
Wayne Morgan
MS Access MVP
"deko" <de**@nospam.com> wrote in message
news:Ve******************************@comcast.com. ..

I have "Allow Design Changes" set to "Design View Only" in the property
sheet for my subform datasheet. But when I have my cursor in a textbox and
press Alt+Return, the property sheet for the textbox comes up.

I've discovered I can prevent this behavior by not pressing Alt+Return.

Is there any other way to prevent the property sheet from coming up? What
property will prevent this?

[deko]

>I did some testing on this to make sure. If the Parent form is set to allow

changes in "All Views", the subform will do as you mention, regardless of
the setting you have in the subform. When a form is opened as a subform, it
is actually an object of the parent form. Some settings still work
independently, but apparently, this isn't one of them.

--
Wayne Morgan
MS Access MVP

That did the trick. Thanks!