why dont you change for field to int rather than butchering the text
field and that will order it as a number rather than ordering it as
text

ie use cint(fieldname) in your rowsource

eg

select cint(numberfieldwhichistext),otherfields from the table