I have a table with an autonumber field called VenId. The id is 10 char and looks like 0000000001. I want to join two tables together by this VenId field. Issue is, the VenId field in the second table is formatted as text (to hold the leading zeros) so I'm getting a TypeMismatch error. I tried changing the VenId field to Number, but when I do this, the leading zeros in the id disappear. What's the best way to solve this?