Re: Weird characters in a textbox
- From: "victorcamp" <victor.campbell@xxxxxxxx>
- Date: Thu, 24 Sep 2009 08:30:38 -0500
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)
"SG" <SG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:81FED509-415C-4422-B22F-5F572A537595@xxxxxxxxxxxxxxxx
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
"Marshall Barton" wrote:
mscertified wrote:
>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?
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.
--
Marsh
MVP [MS Access]
- References:
- Re: Weird characters in a textbox
- From: SG
- Re: Weird characters in a textbox
- Prev by Date: Re: My Applciation does not appear on the task manager
- Next by Date: Re: My Applciation does not appear on the task manager
- Previous by thread: Re: Weird characters in a textbox
- Next by thread: RunSql to Update Records Question (Access 2007)
- Index(es):
Relevant Pages
|
