How to show Line Item in ascending order

[Guest]

Hi,
I have a line item that shows in a form with all the line items in ascending
order. The data type of the line item is in text format. When I am displaying
the following line iems in the form 6000, 8000 and 10,000 the 10,000 line
item is showing up as the first one instead of the last one. I would like to
know if there is any remedy for this without chainging the data type. Thanks

 

[fredg]

Hi,
I have a line item that shows in a form with all the line items in ascending
order. The data type of the line item is in text format. When I am displaying
the following line iems in the form 6000, 8000 and 10,000 the 10,000 line
item is showing up as the first one instead of the last one. I would like to
know if there is any remedy for this without chainging the data type. Thanks

It should be a Number datatype.... but:

Create a query showing all of the fields needed in the form.
Add a new column:
SortThis:Val([FieldName])
Set this column's Sort to Ascending

Base your form on this query.
It will be sorted according to the numeric value of the text field.