how to replace zero with numbers

[Jon]

I have a text box its format as 0.0000
What I want to do is once the user input a number like 123456, the text box
will be filled starting form right to left like this
0.00001
And
0.00012
And
0.00123
And
0.01234
and
0.12345
Finally the number will be as follow:
123456.0000

 

[Arvin Meyer MVP]

Set the

DataType: Double
Format: Fixed
Decimal Places: 4

 

[lebron]

I have a text box its format as 0.0000
What I want to do is once the user input a number like 123456, the text
box
will be filled starting form right to left like this
0.00001
And
0.00012
And
0.00123
And
0.01234
and
0.12345
Finally the number will be as follow:
123456.0000

 

[Roswitha Ostrowski]

Set the

DataType: Double
Format: Fixed
Decimal Places: 4
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com