how do i display the sort arrows in column headers in access 2007

  • Thread starter Thread starter KenBob2
  • Start date Start date
K

KenBob2

I can't seem to find where I can turn on the sort arrows in table column
headers. Any advice?
 
Where are the column headers?
In a table, query, form - data sheet - other?
Some where else?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Hi, In all the trtaining books I have seen, there is an arrow in the field name at the top of each column in table view. In my db's, this arrow never shows, only the pop-up to sort A or D. How do I turn the visual arrow on, so folks using the data base know whether the sort on a column, is A or D when they open it.

Thanks for your help,

Ken



Jeanette Cunningham wrote:

Where are the column headers?In a table, query, form - data sheet - other?
07-Feb-10

Where are the column headers
In a table, query, form - data sheet - other
Some where else

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
GOT INTERFACE?
http://www.eggheadcafe.com/tutorials/aspnet/35c59ac7-0594-4f40-8767-d64c223339e7/got-interface.aspx
 
I think it's:
- office button (that upper left button)
- access options
- current database
- use windows themed controls on a form

Interesting I never checked that box, I'll have to investigate what that
does.

HTH,
Mark
 
Hi
Thanks for the reply. Tried it with no luck. I am trying to show the arrow to the right of the field name in Table (column) headers (Field). A little gray box shows up when I scroll on the RHS of the Field Name, yet there is no arrow indicating the sort direction.

Cheers

Ken



Mark Andrews wrote:

I think it is:- office button (that upper left button)- access options-
08-Feb-10

I think it is
- office button (that upper left button
- access option
- current databas
- use windows themed controls on a for

Interesting I never checked that box, I will have to investigate what tha
does

HTH
Mark

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Create Hidden SharePoint List for Site Owners
http://www.eggheadcafe.com/tutorial...60-917a85a41b08/create-hidden-sharepoint.aspx
 
Just to be clear "can you see the arrow on every column" (as shown in this
image):
http://www.rptsoftware.com/bug/before.jpg

example on the "Last name" column there is an arrow.

If you then click the arrow and choose to sort ascending it will show the
"little arrow" next to the arrow you just clicked.

1. If you can't see any arrow on every column (send me a copy of the
database and I will look at it). Perhaps related to your Access install?
2. if you can't see the "little arrow" after you do a sort, try sorting the
list. This is shown after the list is sorted (not based on what sorting you
might have in the query that drives the list).

Not sure what my last answer was all about? I still don't know exactly what
that option changes?

Thanks,
Mark
RPT Software
http://www.rptsoftware.com



in message
news:[email protected]...
 
Back
Top