How can I hide this bar (see picture) in Access 2007?
Every form has that property, but if it's showing up on table datasheets, the user might want to hide it there, too. In fact, a datasheet is actually an object of type FORM, so it does actually have a NavigationButtons property. But there is no Datasheets collection and you don't get access to these properties through the TableDefs collection. Instead, you have to set Screen.ActiveDatasheet.NavigationButtons = False for each datasheet that you open. If you wrote a wrapper around DoCmd.OpenTable you could do that.
David-W-Fenton
2009-11-23 21:49:36