volgen :)

Check this Video out
Numbers As Text

So, you want to be able to store them in a text field, but yeah, you want to ignore the letters and sort them numerically by just the number portion? Is that correct?

Thanks Sami, the video explains it well.  For a report based on a query it works very well.  For forms where the data sources are tables is there a solution besides a sort order field or making the query the data source for the form ? Try to avoid Queries as data sources for forms .....

If you know SQL, change the name of the table in the Record source to a SQL statement. If you do not know SQL, you should learn it, it will make your life so mush easier. Richards SQL seminars Access SQL Seminars
part 1 and 2 are worth every penny.

so instead of for example CustomerT in the record source, you will have something like:

SELECT * FROM CustomerT WHERE CustomerState = "FL" ORDER BY CustomerLastName

An easy way to get the SQL is to create the query then switch the query to SQL view and copy the statement to use as a record
source then delete the query.

Thanks Sami, got to learn and use SQL !!!!!

Thank you Jorge

You can still use a table-only record source, but with the "Order by" property set to Val([fieldname]), which will sort the form by the numeric value of [fieldname].  See picture below.  [fieldname] needs to be in the table, but doesn't need to be on the form.  Note that Val() will convert anything that begins with a numeric character to a number: Val("2abcde") --> 2.