Excel like checkbox filter

[CIIIHAN]

Good afternoon all!

Is it possible to have an Excel like filter in Access?

If so,
Can someone help me get in the right direction to start with it?

Thanks in advanced!

Have a great week all!

 

[spikepl]

If your form is in Datasheet View, and you don't have more records that some preset limit in Options, and you haven't disabled the ShortCut Menu in the From's properties, then you have such a filter available for each column (in A2007, I don't recall if it exists in A2003 or not) under the little triangle in the column header.

 

[CIIIHAN]

Awesome!
Too bad this is not possible with form view.
No eyecandy but it will get the job done thanks spikepl!

 

[CIIIHAN]

I've changed the colours of a cell in the datasheet view.
(It changes colour depending if a certain checkbox is checked.)
But when I try to print the sheet the cells are not coloured.
How come?