format of number problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 04 Mar 2005 17:36 GMT

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?

Reply to this Message

fredg - 04 Mar 2005 18:00 GMT

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

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message