Weird characters in a textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was looking at the data in a system I developed and came across some
strange characters in a textbox. They look like thick vertical bars but they
aren't the vertical bar character. When I click the zoom box the characters
appear as double quotes but not the double quotes on the keyboard, the double
quotes where the right one and the left one are different like \\ and //. My
question is how did the user get these characters in there and how can I
display them corrrectly? And why does the text box and the zoombox display
the
characters differently?
 
mscertified,
I can only guess some sort of corruption, or... somehow you entered a character that
your text control font can not determine.
Something like a "high" Ascii character like Alt-185. It will display as one thing in
one font and differently in another.

Text controls on forms and reports try to display the character according to the font
selected for it, and that font will try to find a match. If not, a common display is the
thick vertical bar.

Zoom and Table and Query view uses the font defined in Tools/Options/DataSheet, and
that font may have a different character associated with the Alt-185.

Datasheet view (from a form) appears to use the system font as defined in in Windows.
That's odd, but I did test it... one would think Table, Query, and Datasheet view would
all be the same... I changed Options Datasheet font to some wacky font, but DataSheet
view from a form always seems to display in system font.
 
mscertified said:
I was looking at the data in a system I developed and came across some
strange characters in a textbox. They look like thick vertical bars but they
aren't the vertical bar character. When I click the zoom box the characters
appear as double quotes but not the double quotes on the keyboard, the double
quotes where the right one and the left one are different like \\ and //. My
question is how did the user get these characters in there and how can I
display them corrrectly? And why does the text box and the zoombox display
the characters differently?
Click to expand...


The Zoom box uses its own font settings so the difference is
probably just because the fonts have different characters in
them.

It is possible for a user to enter non-keyboard characters
by holding down the Alt key while entering a four digit
character code (starting with 0) using the numeric keypad.
Another (more likely?) possibility is that the text was
Pasted from another program.
 
I am having the same issue. I have set up a form template in Excel. People
fill it in and get it to me. I have written code to go through each form and
pull the data in to a MS Access table. When they type in ", it shows up as
this strange character, that you describe.

At a loss as to what to do. The font in the Excel form is Arial.

SG
 
Look at the AutoCorrect settings within the Access Options. It may be
automatically replacing text as you type, e.g., Printers' Quotes for Regular
Quotes. As to its displaying, you'll have to look at the Character Map
(Start->All Programs->Accessories) to see if the fancier quotes are
available in that font. The Zoom box usually uses a standard font, though
some versions of Access allow you to change it. If you know the font used in
the Zoom box, try that one on the form. To change all the quotes to either
one type or the other, use an Update query, and search for all the ASCII
permutations:
Simple single-quote (apostrophe): Chr(39)
Simple double-quote: Chr(34)
Printers' left (opening) single-quote: Chr(145)
Printers' right (closing) single-quote: Chr(146)
Printers' left (opening) double-quote: Chr(147)
Printers' right (closing) double-quote: Chr(148)
 
Back
Top