473,385 Members | 1,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Funny characters

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.
Aug 12 '08 #1
3 1758
I forgot to mention that I am using Access 2003. Thanks
Aug 12 '08 #2
NeoPa
32,556 Expert Mod 16PB
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
Krandor
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

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

Similar topics

2
by: Fred | last post by:
Hi, I am parsing a small xml document and the parseing goes 'all funny' when parsing this element: <useragent>Mozilla/4.61 (WinNT; I)</useragent> I've created a subclass of...
5
by: francisco lopez | last post by:
hi, well I think I will forget the earthquake-effect, because it doesn´t run in a frame with IE, so I need now another funny prank, but not the format C: fake, I was thinking for example that a...
2
by: Matt | last post by:
I wrote the tcp socket client-server program that the server will echo the message received from the client. In client program: char sendBuf; while(1) { cout << "Enter message:";...
2
by: Salman | last post by:
When I run the below method with a 64 character string as input such as: sr.Encrypt("1234567890123456789012345678901234567890123456789012345678904444"); I get square boxes as my output, which...
2
by: Ramon | last post by:
I send email using ASP.NET using SMTP like this: objMailMessage.From = New System.Net.Mail.MailAddress(strYourEmail) objMailMessage.To.Add(toto@toto.com) objMailMessage.Subject = "Title" ...
4
by: jason.teen | last post by:
Hi, when i am joining on a Column of Text Type with one of Memo type the resulting entry has funny chinese characters! Has anyone else encountered this before? Is there a cure?? Cheers.
2
by: msxkim | last post by:
My web app writes some binary data to a file at the client site via Response.BinaryWrite. This action is accomplished in response to a button click, with C# code behind as follows: private void...
1
by: kellysgirl | last post by:
Step 3 – Add code in the Form’s Load event to select the first radio button: In the Form’s Load event, write code to select the Comma choice in the radio buttons group box. Step 4 – Add code in...
3
by: sophie_newbie | last post by:
Hi, I want to store python text strings that characters like "é" "Č" in a mysql varchar text field. Now my problem is that mysql does not seem to accept these characters. I'm wondering if there...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.