Correct Syntax for Number Field in Email Message

[Bennton]

I created a button in an MS Access 2007 form, when pressed, emails a message that contains an ID number which is formatted as a number. Let's say the field name for the ID number is ID. What is the correct syntax for the number field, ID, so that the number is visible in the email message? A sample code follows:

Private Sub Command55_Click()
DoCmd.SendObject _
    , _
    , _
    , _
    [eMailTo], _
    , _
    , _
    "Email Message Header", _
    "Your ID number is " & [ID] & ".", _
    False
End Sub

[jimatqsi]

Bennton,
You can use the Format command to add formatting to your numbers.

Format ([ID],"#.")

would add a decimal point after your number. You can learn lots about the Format function at http://office.microsoft.com/en-us/ac...001228839.aspx

Jim