Digit grouping in text field

[ppataki]

Dear All,

I have a table that is displayed and modified through a form
One of my fields contains numeric values but as some of them begin with 0 I converted the field to Text data format

Now my question is: How can I set the form to display the values of this field with digit grouping? (like 011111111 => 011 111 111)

Or other solution could be to convert the field back to Number but then I would need to somehow set Access not to remove the leading 0....which I dont know how to do
Could you please advise?
many thanks

 

[ppataki]

Dear All,

I have a table that is displayed and modified through a form.
One of my fields contains numeric values but as some of them begin with 0 I have set the field to Text format

How can I make the form display this field with digit grouping?
(eg: 011111111 => 011 111 111)

Or other solution would be to convert the field to Number but then the leading 0s are removed by Access which I dont want....
Could you please advise?
Many thanks

 

[SOS]

In the format property of the text box put

000 000 000

 

[Mr. B]

When returning the data through the use of a query, try creating a field that will return on the first three characters and then you can group on that field.

Just use the Left() function.