Set input mask to "000" for a number

[cottonland]

I am having trouble with some items numbers not displaying properly. If I have ten items, my report lists them as 1,10,2,3,4,5,6,7,8,9. I understand why this is happening so I am wanting to use a 3 digit number. For example, 1 would be 001. This eliminates my problems with the order in which they are displayed.



Can anyone tell me where I need to set the requirement for the field to list three digits? The field size for the corresponding record in the table is set to 3. I do not however know how to get the program to automatically recognize 1 as 001. I am sorry if this is in the wrong place and is elementary, but I am self taught as you can see.

Thanks in advance for any assistance you can provide.



Mike

[CJ_London]

For example, 1 would be 001

just set the format property of the control in your report to 000. The number will still be recognised as 1 for criteria/filtering and sorting purposes

[cottonland]

Thanks... My report is pulling from a Query, which is based off of a table. A form is used to input the data into the table. Do I set the format property on the Report or on the form that is used to input the data?

[CJ_London]

Do I set the format property on the Report

just set the format property of the control in your report to 000

with regards your form it is up to you

Note that format properties are not passed between objects except for a bound control on a form or report which will take the format (and other) properties from the table field properties at the time of creation of the control.

[John_G]

...my report lists them as 1,10,2,3,4,5,6,7,8,9.

That suggests that they field type in the underlying table is text, not numeric. If you change the data type to numeric, then the sorting will be done correctly, and you only need to use format on your forms and reports to display it with leading zero's.

[cottonland]

Thanks.... That did it.... Now on to the next Gremlin.....