Hi,
Sorry for repeating the question. I am facing problem when working in vba editor. I need to type single/double quotes twice and then delete one of them. One solution that's on the web is to change the Keyboard language in "Region and Language" to English (United States ) - US. I checked settings in my laptop and found that the keyboard language is set to English (United States) - US already. I am using Win 7. Not sure what's wrong.
8  19507 
When you say twice do you mean two pairs of quotes (""<Some code here>""), or two quotes meaning one opening and one closing quote? ("<Some code here>")
You need to give more explanation on what you're trying to achieve.
hi Adam
What I meant was, If i need one single/double quote, I have to type twice or have to type a character after that, in order it to become visible.
So if I type once, it does not appear. If I press double quote again or any other key, it appears.
Oh right.
That's more a laptop issue than one related specifically to MS Access or VBA.
Are you sure the setting is English (United States) and not anything like English International (United States)?
Even if it's already set to English (United States), it might be worth trying to change it to something else, log out, log in, changing it back, log out, log in, and see if that does anything.
Occasionally systems can get confused - I often have something like MS Word telling me it's using UK English spellchecking, yet it's suggesting US English spellings.
NeoPa 32,556
Expert Mod 16PB
I'll move this to the Windows forum where hopefully it will find more appropriate experts.
Hi murthyspd!
I found this old thread which also talks about changing the keyboard layout. It seems, there are two English US layouts - one of them "International". That's the one you don't want. If you already have the correct one activated, try switching to the wrong one, saving the settings and testing that. It should work just like now. Then change it back. Theoretically, then it should work as you want it to.
Does that solve your problem?
Greetings,
Nepomuk
NeoPa 32,556
Expert Mod 16PB
I suspect this is still the problem. You say in the OP that you already have this set to English (United States) - US already, but also that you are using Windows 7. I think it's quite possible that the ability to specify accented characters (that this problem appears to be related to) is simply found in a different place in this new version of the operating system. I suggest you check through your Control Panel applets for anything which may be related and go through the options found within them until you discover what may effect this.
Please let us know what it turns out to be if you do find it. I'm sure there will be others who also need this information. Best of luck :-)
This has happened to me in VBA or while editing a macro. This can occur if you accidentally press CTRL + Shift at the same time while typing. Press CTRL + Shift again to undo this annoying issue. It's maddening to try and figure this out if no one else knows what in the world you are talking about!
I had the exact same problem in Excel and vba. gregla1's solution worked for me. ctrl+shift pressed together toggles the problem on and off. Thanks!!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: sinister |
last post by:
The examples in the online manual all seem to use double quotes, e.g. at
http://us3.php.net/preg_replace
Why? (The behavior is different with single quotes, and presumably simpler
to...
|
by: Dynamo |
last post by:
Hi,
I am still confused as when to use single or double quotes.
This works:
echo "<td>" . $row . "</td>";
and this does not
|
by: Jakanapes |
last post by:
Hi all,
I'm looking for a way to scan a block of text and replace all the
double quotes (") with single quotes (').
I'm using PHP to pull text out of a mySQL table and then feed the text
into...
|
by: Joel |
last post by:
Hi,
I incorporated a function in my code that whenever I use a string variable
in an sql statement if the string contains a single quote it will encase it
in double quotes else single quotes.
...
|
by: deko |
last post by:
I'm trying to log error messages and sometimes (no telling when or where)
the message contains a string with double quotes. Is there a way get the
query to insert the string with the double...
|
by: (PeteCresswell) |
last post by:
Is his just a flat-out "No-No" or is there some workaround when it comes time
for SQL searches and DAO.FindFirsts against fields containing same?
I can see maybe wrapping the value searched for...
|
by: Brett Hofer |
last post by:
I must be missing something - Im a veteran C++ programmer now working with
C# overall I like the language but find many weird changes... Anyway Im
writing code behind an aspx. In this one C#...
|
by: gar |
last post by:
Hi,
I need to replace all the double quotes (") in a textbox with single quotes ('). I used this code
text= Replace(text, """", "'"
This works fine (for normal double quotes).The problem...
|
by: Justin Fancy |
last post by:
Hi everyone,
I need to replace all instances of a double quote(") with two single
quotes('') in a text file. I already have some replacements of strings
going on, but I tried this one, but the...
|
by: Yearwood |
last post by:
Hi, I'm basically trying to import a CSV into an ACCESS database. Sample date is shown below:
"",10173,"Development Manager - Social Economy Sector","Trust Bank",10153,,"Lolalll Pudd","Meet the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
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...
| |
