Access email button messing up numbers

[ninjafly]

I'm rather a novice with Access and I desperately need help to solve an access report problem. I placed a command button to email a report which it does, but the report which has a column with part numbers in the format "10-12345678, " displays totally screwed up. Eg. 10-04004215 shows up as "512816," and so on. The data type for this PartNumber column is formatted as Text because some of them have 10-TS-12345678. Need help please.

[SoftwareMatters]

Does the report display correctly before you send it?

[ninjafly]

Hello SoftwareMatters,
Sorry for the delayed reply...I was out of internet connection range :-)

Yes, the report displays correctly before I send it, but gets totally screwed up numbers when I email it and view the results.

[dcrake]

This is usually the case if the first item in the list could be construed as a calculation, such as 10-12345. What you may need to do is wrap CStr() around it even if it is a string type.

David