Replace Function 1

[jgsteeldev]

It appears that the Replace function is not available in Access 97. Does anybody here know how to replace text in a string in Access 97?

Here we go Royals! Here we go!!!!!

 

[RoyVidar]

RickSpr has created some functions for those still on 97;-)

Check out faq705-4342.

Roy-Vidar

 

[jgsteeldev]

thanks

Here we go Royals! Here we go!!!!!

 

[cmmrfrds]

Do you have a reference set to the VBA library that contains the Replace function?

 

[PHV]

cmmrfrds, the Replace function came with Office2k.

 

[cmmrfrds]

PHV, it has been awhile since I used Access 97. I thought I had used Replace with 97, but that may be due to fading memory. Anyway, thanks for the correction.