Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
scanning input
- Thread starter priapus
- Start date
Additional information:
Their is a function built into Access 2000 up called Replace and it takes a string, finds a character or string of characters and replaces it with whatever character or string of character you need. Here's the usage of that function:
[tt]
Replace("MyString","'","`"
[/tt]
HTH Joe Miller
joe.miller@flotech.net
Their is a function built into Access 2000 up called Replace and it takes a string, finds a character or string of characters and replaces it with whatever character or string of character you need. Here's the usage of that function:
[tt]
Replace("MyString","'","`"
[/tt]
HTH Joe Miller
joe.miller@flotech.net
- Status
Similar threads
- Locked
- Question