Replacing * from Access data

[mary mathews]

Hi,
I want to replace * with space in the MS Access data.
And i tried to use the Find and Replace option,but for all other chacters its working.but for * its not working.

Can anybody help

[Stewart Ross]

Hi Mary. **EDIT** Ah, you may be using the find and replace menu options. As far as I can tell you cannot find and replace wildcard characters using the built-in menu options.

However, there is a Replace function which can do the string replace for you - check it out. You will need to build it in to an Update query to use it, however.

In testing Replace you can refer directly to the asterisk character and it will work fine in an update

=Replace (OldString, "*", " ")

or you can use the ASCII character equivalent

=Replace (OldString, Chr(42), " ")

-Stewart

Hi,
I want to replace * with space in the MS Access data.
And i tried to use the Find and Replace option,but for all other chacters its working.but for * its not working.

Can anybody help

[mary mathews]

Thanks Stewart,,Anyway i got the same answer before itself..nyway thanks for the help...