Parsing Hyphens out of web address Shell Command

T

Tom Perot

Dim StartDoc As Long
If Not IsNull(Me!SiteURL) Then
StartDoc = ShellExecute(Me.Hwnd, "open", Me!
SiteURL & [Tax_ID], "", "C:\", SW_SHOWNORMAL)
End If

Me!SiteURL for example is
http://www.traviscad.org/travisdetail.php?theKey=

Tax_ID is 01-011-302060000
in my database.

When combined it needs to look like:
http://www.traviscad.org/travisdetail.php?
theKey=01011302060000

I need to parse the hyphens out of the Tax_ID only when
it runs the code above so the website will open correctly.
Is there anything that I can put in front of the [Tax_ID]
field to accomplish this task within this code.
 
Top