By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,963 Members | 1,382 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,963 IT Pros & Developers. It's quick & easy.

Funny characters

P: 72
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.
Aug 12 '08 #1
Share this Question
Share on Google+
3 Replies

P: 72
I forgot to mention that I am using Access 2003. Thanks
Aug 12 '08 #2

Expert Mod 15k+
P: 31,758
Not much to go on here really.

What is the formatting set to of the control on the form where you notice this behaviour?
Aug 13 '08 #3

P: 50
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_TempString,Chr(Weird_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.
Aug 14 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.