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

Quotation Mark Differences

P: 22
I am getting different Query results depending upon whether I type directly into Access or whether I type first in Word and paste into Access.

Typed Directly into Access Query
Expand|Select|Wrap|Line Numbers
  1. Test1: "Hello"
Query Datasheet view shows the word "Hello"

Pasted Into Access Query from Word
Expand|Select|Wrap|Line Numbers
  1. Test2: “Hello”
Access adds brackets to what I have pasted and changes my paste to Test2:[“Hello”]
Query Datasheet view Prompts "Enter Parameter Value"

The only difference is that the quotation marks typed directly into Access are completely vertical. The quotation marks pasted into Access from Word are slanted/curvy.

Is this an Access quirk?
Or is there something for this Novice needs to learn?
Attached Images
File Type: jpg Quotation Mark Differences.JPG (32.5 KB, 471 views)
Feb 13 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,366
Word will sometimes convert quotation marks to a different character for aesthetic purposes. If you look carefully at the characters, they are not quotation marks but double grave and double acute accent marks. They look similar but are different from quotation marks.
Feb 13 '12 #2

Expert Mod 15k+
P: 31,494
Paul Howarth:
Or is there something for this Novice needs to learn?
There you go. As Rabbit says, the characters may look like quotes (') or double-quotes (") but are actually completely different characters. This is one of the main reasons we insist on [code] tags for posting code. These characters show up quite differently in that font.

We also recommend that no-one ever works in Word, or any other word processing package when dealing with code or data. They are particularly badly suited to such work. Use a text editor instead (Notepad will do, but one with macro facilities may be worth your while getting into instead).
Feb 14 '12 #3

Post your reply

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