Access 2007 -- Disable autofiltering in datasheets?

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

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

Clint

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

Cheers
 
W

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top