whit ado abd vb6 classic

[sal21]

Have a column in access table with value similar:

879
9876
456
...

The field are formatted text

How to update all value in this column with #0000 and return:

0879
9876
0456
....

???

[HansV]

Try this:

UPDATE [TableName] SET [FieldName] = Format([FieldName],"0000");

Substitute the appropriate names.

[sal21]

Try this:

UPDATE [TableName] SET [FieldName] = Format([FieldName],"0000");

Substitute the appropriate names.

Great! tks.