format of number problem

  • Thread starter Thread starter Rob
  • Start date Start date
R

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?
 
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?
Click to expand...

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.
 
Back
Top