Hi,
I am trying to append an auto number field from one table to a text field in another table but I want to keep the format (0000000) of the auto number field. Right now let's say the number in the auto number field is 0000021. When I append it into the table with the text field it displays it as just 21. I have tried everything I can think of to no avail. I'm pretty familiar with Access, but only a little bit with code. Can anyone help me out? I would be so grateful
Christy
I am trying to append an auto number field from one table to a text field in another table but I want to keep the format (0000000) of the auto number field. Right now let's say the number in the auto number field is 0000021. When I append it into the table with the text field it displays it as just 21. I have tried everything I can think of to no avail. I'm pretty familiar with Access, but only a little bit with code. Can anyone help me out? I would be so grateful

Christy