How to update/edit all entries in a column with leading zeros(0) ?

[omyurs]

I have access97 database with table(mytable) and have a columns(amount, name,ta, da).

I want to perform calculations only on "AMOUNT" column.

Amount column type=text (i.e. string)
Size=12 (maximum length is 12characters/digits)

In this amount field user enters data like(1234, 50000, 3547446,9868686 or more entries). I want to update all entries on a single button click with leading zeros(0) so that total digits/characters become 12.
for example if user enters "5874689" then
clicking on the button, this entry should become "000005874689".

All entries in this column should become of 12 characters/digits in size with leading zeros.

and if there are already 12digits/characters are there in an entry then we will leave it and move to next entry.
This process will work from bof to eof.

I want to insert zeros(0) to make all entries of 12 characters/digits.

User can enter any number of characters/digits but we have to process all entries and make them 12 characters/digits by inserting zeros(0) into them.

for example :
if user enters 25636
then 000000025636
or
if user enters 123
then 000000000123
or if user enters 123456789123
then 123456789123 (becausethere is already 12 characters).
all entries in the column should be updated with the format explained above with one button click.

 

[Taff]

Hi omyurs,

Maybe this will help.

Taff.