Mark L. Breen
subs at solution-providers.ie
Thu Jul 31 02:21:49 CDT 2003
Hello Rocky, I have just thought about it and without getting complicated and using two columns in the recordsource to specify the sort order I cannot see a simple way to get tilde to go to the top of your ascending list. I presume that you are concatenating on the tilde as in Mark Breen John Colby ~Rocky Smolin Could you just replace the tilde with Z~ or if your really need it, ZZ~ If they are at the bottom and out of alphabetic order anyway, I guess that they are some sort miscellaneous items, perhaps the Z will not matter. If you need to later display the names you could use a Right(fieldname, 2) I know that I am teaching my granny to suck eggs, but just in case. Otherwise, hello to you, Mark ----- Original Message ----- From: Rocky Smolin - Beach Access Software To: AccessD at databaseadvisors.com Sent: Wednesday, July 30, 2003 6:57 PM Subject: [AccessD] Tilde Sort at the top Dear List: I need a special character to sort the contents of a combo box so that items with the special character sort at the bottom of the list. (The items come from a table). So I tried using a tilde ~ because its ASCII value is 126, greater than any number or upper or lower case letter. But it sorts to the top of the list. Is there a simple explanation and/or workaround? Much thanks in advance and regards, is ------------------------------------------------------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030731/6de16d5f/attachment-0001.html>