My bad.

Yes all in access.

Yes, that's what I would like for it to show.

Yes those values are pulled from database "A" which I will then use to pull more values from databse "B".

Basically database A gives me account #'s cut in half like 123 18. I need them to be like 00000001230000000018 (20 characters long) because that's the only field I can use to link up to database "B".