how to insert up/down arrows in sort button

[mdavid]

Hi,
I have a toggle button that sorts a column ascending / descending depending on previous sort. Would like to display up / down arrow image instead. No idea where to get the images, or how to toggle between two images in button. I'm using Access 2016
Any help greatly appreciated.
Thanks
David

[moke123]

one way is to use wingdings
https://www.thespreadsheetguru.com/b...heet-printable

[Micron]

If a control has a picture property you can embed any of the built in images by clicking on the ellipses (...) in the property sheet. Image control possibly excepted. Can't say for certain as I'm on my phone on the deck enjoying the sun and a wobbly pop or 2.

[isladogs]

Have a look at my Student Target Grade Explorer example app where I've done exactly what you want
See http://www.mendipdatasystems.co.uk/m...ter/4594454290

[mdavid]

Thanks for making this access db available, I've downloaded it and am trying to understand - the Surname button which toggles the sort asc/desc, I found the onClick event "=GetOrderBy("Surname")". Excuse my ignorance but where/how can I find the rest of the code that makes the sort work?

Thanks for your help
David

[mdavid]

OK making progress, found - Private Function GetOrderBy(FldName As String), but how does the up/down arrow get into the Surname button?

[isladogs]

The up/down images are in the Image Gallery for the app

Look at the code in GetOrderBy between the two broken lines. It includes this section

If strOrderBy Like "*DESC*" Then
   strSortBy = " Reverse sorted by "
   If Me.Controls(NewControlSort).Tag = "S" Then Me.Controls(NewControlSort).Picture = "up"
Else
   strSortBy = "Sorted by "
   If Me.Controls(NewControlSort).Tag = "S" Then Me.Controls(NewControlSort).Picture = "down"
End If

The form load event includes this which sets the sort to Surname and so adds the down arrow to cmdSurname

'CR 09/01/2019 - show visual sort by surname
GetOrderBy ("Surname")

The code to do this was an enhancement to the example app that was suggested by AWF member Salvatore Fricano
It was a neat bit of code which works in A2010 or later.

Hope that helps

[mdavid]

Hi Colin, really appreciate all your help, nearly have all the pieces - just missing where I can find/download the up/down arrow images.
Thanks
David

[isladogs]

Can't remember where I got those images from.
There is probably a simple way of exporting images from the image gallery.
Otherwise lots of free images online you could use e.g. https://www.freeiconspng.com/images/up-arrow-png

EDIT
Another alternative would be to import all your database objects into mine so you get the image gallery items.
Then delete all my database objects-tables, forms etc
That does seem a bit absurd but it would work.

[mdavid]

Hi Colin, FYI found alt-codes 30 ▲ and 31 ▼

Thanks
David