Funny characters

[ielamrani]

Hi,
I have a form that's linked to a query. when I run the form, one of the text boxes shows funny character (%!,<!䬃!). All the other text boxes are fine except this one. When I run the query by itself it's fine. Does anyone have the answer to this? I did some search in the web but in vain. Thanks in advance.

[ielamrani]

I forgot to mention that I am using Access 2003. Thanks

[NeoPa]

Not much to go on here really.

What is the formatting set to of the control on the form where you notice this behaviour?

[Krandor]

The simplest solution is to:
1. s_TempString = me.textControl 'Gets the contents of the control into a string.

2. find the ASCII values of each of the strange characters (google ASCII chart for sites).

3. s_TempString =Replace(s_Temp String,Chr(Weir d_ASCII),"") 'this replaces the weird character with a null string (basically just gets rid of it).

4. Repeat step 3 for each strange character.

5. me.textControl = s_TempString
Doevents 'returns the updated string into the text field.

6. Do whatever you were going to do next.