I have a table with a Parcel # field which is set up as a text field because some numbers have a letter after them. (10A) In order for these to sort numerically in my form I created a field in my query using the Val Function. This makes it sort right in the query (1 is before 10). However, when I use the form as a subform, it doesn't sort right. The 10 is listed before the 1. How do I fix it?