MS Access context menu filter message The object d

问题:

I have a form that I open in either datasheet or continuous forms view with four fields bound to text columns in a linked table. If I right click for the context menu and filter on column 1 or 2 equal to one of the values it filters OK; If I try to filter on field 3 or 4 I get the message "The object doesn't contain the Automation object 'me'". If I select 'Text Filter' on fields 3 or 4 and enter some text, it filters OK.

I would be grateful if anybody that has experienced this can tell me why it happens and how to either trap or stop it.

Thanks

回答1:

The problem is with Conditional Formatting on the columns. If I remove conditional formatting, filtering via the context menu works fine, replace the formatting and filtering shows the message (but still filters correctly!!)