brian f
07-02-2003, 04:35 PM
Im using an access db with first field as a name field which needs to sort alphabetically.
If i start off with 20 rows, 'a' to 't', my app brings them up in order. If I change say the 'a' to 'pp' access rearranges the table so that b is now first and pp is 16th but when i run the app it brings them up in the original order so 'pp' is first.
The only way the app will display the items in correct sequence is if i copy the entire table and rename it.
I have not had this problem with number fields ie numbers always seem to put themselves into the correct order, but not letters.
(the field property is of course set to ascending)
Any ideas?
If i start off with 20 rows, 'a' to 't', my app brings them up in order. If I change say the 'a' to 'pp' access rearranges the table so that b is now first and pp is 16th but when i run the app it brings them up in the original order so 'pp' is first.
The only way the app will display the items in correct sequence is if i copy the entire table and rename it.
I have not had this problem with number fields ie numbers always seem to put themselves into the correct order, but not letters.
(the field property is of course set to ascending)
Any ideas?