Hiding the Filter button

[ShiftyJaffa]

Hi

This may be a no brainer, sorry in advance if it is, but I've just searched this site and the net and access help with no luck so far.

I've just recently upgraded to access 2007 a few days ago and want to hide the filter button (and possibly the search field) next to the navigation buttons at the bottom of the screen. I want to keep the filter on the form, I just don't want my users to be able to accidentally turn the filter off revealing other records.

Thanks in advance

Paul

 

[odin1701]

DoCmd.ShowToolbar "Toolbar Name", acToolbarNo

You need to do that in the VBA.

However, if you don't prevent users from adding toolbars back, they could just right click the toolbar area and add it back.

Edit:

Oh for 2007....I haven't worked with it so I'm not sure if they added filter buttons? If they are down by the navigation buttons I would imagine there is the ability to remove those in the options of the form.