Replace (in Access 97)

[Guest]

Hello,

I am trying to programatically replace ":" with "." for all records in all
fields in a table. Everyone mentions the replace funtion but this is not
available in Access '97.

Can anyone suggest another way to solve this problem?

I don't want the user to undertake the replace themselves as they will not
see the data.

Thanks,

Martin

 

[Douglas J. Steele]

There are Replace functions out there that have been written to work in
Access 97. One sample is http://www.mvps.org/access/strings/str0004.htm at
"The Access Web"

 

[Guest]

Thank you, I will use this.

Martin

There are Replace functions out there that have been written to work in
Access 97. One sample is http://www.mvps.org/access/strings/str0004.htm at
"The Access Web"

 

[Guest]

Hi Martin

Try:

Spin around each record in each field and use coding:

Dim strOld, strNew

strOld = string contents you want to convert
strNew = "" ' this is a two " 's
For n = 1 to Len(strOld)
If Mid(strOld, n, 1) = ":" then
strNew = strNew & "."
Else
strNew = strNew & Mid(strOld, n, 1)
End If
Next n

strNew now contains the new string with the :'s replaced by .'s

Let me know if you need to know how to spin around the fields/records.

Cheers.

BW