"1. Neil?Peter" The tiny * is really a square?

[robdunfey]

Hi,

I have some data from Japan. A typical value for a cell is shown below:

1. Neil?Peter

The little character inbetween Peter and Neil is shown as a square in Access, a question mark in Excel. But when I try find and replace in access it I copy the litte square, but it is pasted as a tiny asterix in the find box, meaning it is not found?

Any help in resolving how to replace this character appreciated,

Rob

 

[MakeItSo]

Try by displaying it in any textbox on any form. Set the font of the text box to
Lucida Sans Unicode (or Arial MS Unicode).

Then you will see, which character you are truly dealing with, resp. which character is in the table.
If you cannot find/replace directly in the table, use a recordset in a form to cycle through all records.

Dim rs as recordset
Set rs=currentdb.openrecordset("your table", dbopendynaset)
rs.lockedits=false
rs.findfirst "[your field] LIKE '*" & Chr(123) & "*'"
Do while not rs.nomatch
rs.edit
rs![your field]=replace(rs![your field], chr(123)," &quot
rs.update
rs.FindNext
Loop

Hope this helps,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de