Hello All
I am trying to format an number (long integer) into text to send an automated email from Access. I have the format in the table and am able to get this format to work everywhere but when I try to format the number while sending email.
so the number is 1 (no leading zeros), when formatted on the form it shows as NC-00001. But when sending email you cannot use the same custom format "NC-1"0000
Any help would be greatly appreciated
Thanks
Raven
I am trying to format an number (long integer) into text to send an automated email from Access. I have the format in the table and am able to get this format to work everywhere but when I try to format the number while sending email.
so the number is 1 (no leading zeros), when formatted on the form it shows as NC-00001. But when sending email you cannot use the same custom format "NC-1"0000
Any help would be greatly appreciated
Thanks
Raven