rs in a text field

[weee]

I'm trying to make an update application for the user to edit his user name.

the problem is when I'm having a text field and the name in it is something like: OGR"DON" it shows me only GOR and that's it.

Why's that? what to do?

[buntine]

Does it show you OGR before the data has been entered into the database? Or is showing like this after you request it from the database?

MS Access doesnt like single quotes much... It shouldnt have problems with double quotes, though.

Dim strSingle, strDouble

'|Replace single and double quotes.

strSingle = Replace(rs("fieldName"), "'", """")
strDouble = Replace(rs("fieldName"), """", "")


Regards,
Andrew Buntine.