Access 2007 -- Disable autofiltering in datasheets?

[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.

 

[NetworkTrade]

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....

 

[Clint]

AllowFilters=false on the data tab in the property sheet with the form
selected..

Cheers

 

[WPW07]

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?