In v5 the individual values in multivalue MV) fields are listed in the order they were added, i.e. by creation date.
In v6 this was altered so that values are displayed in alphabetical order.
Note that in scripting (only VB tested) the order of the values is always creation date regardless of the version of the client. In other words, the VB v6 access behaves like the v5 and not v6 client when returning MV field values. There is further FAQ information on VB and MV fields.
Question: Listings for multivalue fields - differences v6 vs. v5 [FAQ00245.htm]
Last Update:- 31 May 2006
Site and articles © Mark Anderson 2001-2007 - Visit my home page