Access 2007 -- Disable autofiltering in datasheets?

  • Thread starter Thread starter WPW07
  • Start date Start date
W

WPW07

Hello Everyone,

I just stumbled onto something interesting and was wondering if anyone
else has experienced it and how they fixed it.

I've got a datasheet subform developed in an Access 2003 database.
Users can click on a row and delete the record on the datasheet.
However, when we open the database using Access 2007, Access 2007 sets
autofiltering on each column, so I can't select the row--only
columns.

I can't seem to find how to disable this feature in the Access 2007
Options area.

Thanks for your help.
 
will be interested if someone knows

I don't have datasheet as subforms - just continuous forms as subforms; and
on these I have no problem deleting a row in 07....just put cursor all the
way to left where the active arrow is...and cut....

you could whip up a form I suppose as a test work-around to see if works
with a form and replace the datasheet....
 
AllowFilters=false on the data tab in the property sheet with the form
selected..

Cheers
 
Thanks, but that didn't correct the problem. Does anyone know what
Microsoft has to say about this issue? I can't seem to find anything
in the KB either. Is it a known bug?
 
Back
Top