property list in datasheet view

[Andy74]

Hello Everybody,

I have something that looks easy but it makes me sick! I want to avoid the properties list to pop out when a form is viewed in dsview. I remember there was a property to set that but I cannot find it. Thanks

 

[Old Man Devin]

Hello Everybody,

I have something that looks easy but it makes me sick! I want to avoid the properties list to pop out when a form is viewed in dsview. I remember there was a property to set that but I cannot find it. Thanks

If you turn the property sheet off using the property sheet button in the ribbon then it should stay closed whenever you close and reopen the form. Or least that is my experience in Access 2010.

If you can't stop it coming up, try putting the datasheet form as a subform on a blank regular form and then turning off the properties from the ribbon in the same way.

 

[Andy74]

thanks, anyway it looks there is no property for that.

 

[vbaInet]

Are you trying to hide it for your users or just yourself?