format of number problem

[Rob]

How do I change the format of the number I am entering on
my table to allow 0000345 instead of it shortening it and
making it 345 I need it to always have YTR before it is
displayed on my form how do i change these two settings?

 

[fredg]

How do I change the format of the number I am entering on
my table to allow 0000345 instead of it shortening it and
making it 345 I need it to always have YTR before it is
displayed on my form how do i change these two settings?

Set the control's Format Property to
0000000

If the "number' is not going to be used in calculations, then it
should be Text datatype. As Text, the preceding zeros would be stored
with the number value.
In which case you would not be having this problem.