Using Twilio with Access to send & receive text & voice messages

[shadow9449]

To anyone using this solution, I just want to point out one small thing:

I have a real user beta testing and she found that if she includes an ampersand in the message, anything after the & does not send as the POST command sees the & as a parameter marker. My solution is to make this simple change on the OK button (using the example from the blog post):

    Dim msg As String
    msg = Replace(Me.txtMessage.Value, "&", "%26")

That was the & is encoded properly before it's sent.

 

[isladogs]

I can see why that would happen though I've never had anyone report back a similar issue with my original code.
Possibly just luck or the fact that I use functions to build the strings??

 

[shadow9449]

I can see why that would happen though I've never had anyone report back a similar issue with my original code.
Possibly just luck or the fact that I use functions to build the strings??

1) Ampersand is not a common character. It HAPPENS to be that the company beta testing the SMS screens has an & in the company's name.

2) As far as the functions you used, if you used a URLencode function then it will convert the & and any other special characters so you might have gotten around the problem that way.

 

[isladogs]

Actually I think '&' is a common character.
At some point I'll check my code ... just in case
Thanks for the 'heads up'