Format Phone Number

[Vaimpir]

I have a form that I use to send emails to employees in the office. One of the fields in the form is for phone number. The field is formated as: @@@-@@@-@@@@. The problem I have in when the number is placed in the body of the email it shows as: @@@@@@@@@@. Is there a way to format the number in the email to resemble the field on the form.

Steven

 

[Vaimpir]

Is there no way to make this work.

Steven

 

[mdemarte]

You should be able to apply the same formatting to the field exported to the e-mail as on the form. If not, then use an unbound text field where you create the result you want -- like this

=Left([phoneno],3) & "-" & Mid([phoneno],4,3) & "-" Right([phoneno],4)

 

[Vaimpir]

Thanks for the response but I forgot to put in my post that the email does not come from a report. The email is being written in the VB in the On Click event of the command button.

Steven

 

[mdemarte]

What I posted should still work, if the unbound text field is called [text32] then that is the field to use in your VB code.

 

[Vaimpir]

Oh ok I will give it a try.

Steven

 

[Vaimpir]

Thanks for your assistance it works great.

Steven