Zero Problem (Access 2000)

Topic

New Reply

I want to append 7 zeros to the figure but i cant.If i have not zeros then it is OK, but if i have to append zeros then nothing happens.How can i avoid this problem ? In my case, according to the attachement, only the appending from the first office , number 1 does not work. in the the other offices, where there is no 0 as the fist figure, it is ok.How can i append the zeros for the office 1 ?
i will be much obliged for your suggestions

Reply | Quote

Replies

PaymentID is a number field. Adding 0 to a number doesn’t change the number: 3+0 = 3, 753+0 = 753 and 2140395+0 = 2140395.
If you want to show the PaymentID with 7 digits, including leading zeros if necessary, set the Format property of this field to 0000000. This will *not* change the value stored in the table, but it will change the way the value is displayed.

Reply | Quote

it is wonderful.I can now add the zeroes. Thank you Hans !

Reply | Quote