Access 2007 Quick Sort/Filter Missing

  • Thread starter Thread starter bcap
  • Start date Start date
B

bcap

As we all know, in Access 2007 we have this nifty little quick sort/filter
thingummy in the column headers of datasheets.

I've come across a couple of threads where people wanted to know how to get
rid of these, although no-one seemed to have an answer. However, I have the
opposite problem: on one computer at my current client's office, the little
arrow for the drop-down menu, and the associated gubbins (e.g. the filter-on
icon) are missing! And the user (the sales director) wants them back!

To explain further:

(i) The functionality is still there. If I point at the right-hand edge of
a column header where the arrow should be, the little square where the arrow
should be changes shade when it gets the focus, and clicking produces the
drop-down menu. What is missing is the image of the arrow etc.

(ii) This doesn't just affect my application. I created a new, test
database (accdb) on the affected computer, with one table and a form in
datasheet view, and the same issue is present.

The 'puter is running Win XP Pro SP2, with Access 2007 SP1.

Any suggestions gratefully received!
 
Problem solved. The offending computer had had the DPI setting in Windows
changed to Large Size (120 dpi). Changing it back to Normal caused the
missing images to reappear.

I experimented with a couple more computers with the same result: changing
the DPI setting to Large causes the quick sort/filter button images to
disappear. Looks like yet another bug in A2007.

n.b. this was all with Win XP, I don't know about Vista.
 
Back
Top