Replace/Encode Using Access 97

I have a string such as "4th & Main" that I need to encode into a url. I have looked a urlencode, and Replace using VB and Asp but neither seem to be available in Access 97.

How could I convert 4th & Main to something like 4th %26W Main. Using Microsoft Access 97 code.

Thanks
Brandon

I doubt Access has any built in function to convert strings to URL encoded. You might want to look at some code samples posted on Planet Source Code :)