How to remove &NBSP from my form

[nickgoldie]

My form shows &NBSP and &AMP although the data looks fine in the database as a memo field (rich text).



Example:
1.Eliminate funding for Web Q&A on the city website.
2. Eliminate the citizen and visitor tracking software that is interfaced with the INFO database.  This software is used  for questions and inquiries for city services. With the upgrades to the city's new website, Web Q&A is no longer a compatable tool.

How do i fix this in my form? It is also affects all my reports.

thakn you!

[orange]

You have remnants of HTML in your data. You might try to search for " removing HTML Tags and constants from text".

Here's one link http://www.codeproject.com/KB/asp/removehtml.aspx

[joelmeaders]

Use this function:

Function CleanStr(stInp As String, stSrch As String, stRepl As String) As String
'This function will search through a string and replace
'the specified text with a specified replacement.
On Error GoTo ErrorHandler

Dim Result As String

Result = stInp
If InStr(stInp, stSrch) > 0 Then
Result = Replace(stInp, stSrch, stRepl)
End If
CleanStr = Result

ExitProcedure:
Exit Function

ErrorHandler:
MsgBox "Unable to clean string.", vbExclamation, "String Error!"
Call AddErrorEvent(Err.Number, Err.Description, "CleanStr()")
Exit Function
End Function

Remove the "AddErrorEvent" line because that's a custom function of mine.

Use:
Example MemoField: "this is the &nbsp same time as yesterday"
CleanStr(MemoField, "&nbsp", "")

Returns: MemoField: "this is the same time as yesterday"

[RuralGuy]

The Replace() function will do the same.

[joelmeaders]

The Replace() function will do the same.

Good call lol. I don't remember why I used this function but I'm sure there was a reason.

[orange]

If you know the exact strings you want to replace, then as Joel and Allan have said - you can use the replace function.

If you or some one has copied material from the web into a memo field, and there are various html "thingies" embedded within text, then you may want an html remover.

Good luck with your project