Format Number to text in email

[niteraven]

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

 

[Andrzejek]

How about:

Dim i As Integer

i = 1

MsgBox "NC-" & [blue]Format(i, "00000")[/blue]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[niteraven]

Hi Andy

Thanks - that worked

I just used:
varNcNum = Format(Forms!frmName!Nonum, "0000")
VNCno = "NC-1" & varNcNum

Worked like a champ! Thanks again!

Raven

 

[Andrzejek]

You may make it even simpler by:
[tt]
VNCno = "NC-1" & Format(Forms!frmName!Nonum, "0000")
[/tt]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.