Text in Access memo field

[Alex H]

Hi
I have a number of Access Memo fields, and when the users enter a set of
quote marks ("), they are simply getting a verticle line (|)

Can anyone advise - can you use quote marks in memo fields are how can I get
round this

thanks

Alex

 

[Guest]

Tell your users to use single quotes instead.

Steve

 

[John W. Vinson]

Hi
I have a number of Access Memo fields, and when the users enter a set of
quote marks ("), they are simply getting a verticle line (|)

Can anyone advise - can you use quote marks in memo fields are how can I get
round this

I suspect they're entering Word or WordPad "smart quotes". The " character,
ASCII code 34, is distinct from the left and right smart quote characters “ ”
(ASCII codes 147 and 148).

John W. Vinson [MVP]

 

[Alex H]

Hi and thanks for your post

Yes, the users wil be creating in Word and then pasting into Access

What is the best way for them to be able to do this - Is it possible to
change settings in Word so that Ascii 34 is ued?

Alex

 

[John W. Vinson]

Hi and thanks for your post

Yes, the users wil be creating in Word and then pasting into Access

What is the best way for them to be able to do this - Is it possible to
change settings in Word so that Ascii 34 is ued?

From Word help for "smart quotes":

To turn this feature on or off:

On the Tools menu, click AutoCorrect Options, and then click the AutoFormat As
You Type tab.
Under Replace as you type, select or clear the "Straight quotes" with "smart
quotes" check box.
Note You can find and replace all instances of single or double curly quotes
with straight quotes in your document. To do this, clear the "Straight quotes"
with "smart quotes" check box on the AutoFormat As You Type tab. On the Edit
menu, click Replace. In both the Find what and Replace with boxes, type ' or
", and then click Find Next or Replace All.


If the users don't want to give up smart quotes in Word, you could run an
Update query updating the memo field to

Replace(Replace([memofield], Chr(147), Chr(34)),Chr(148), Chr(34))

John W. Vinson [MVP]

 

[Alex]

Thanks John

Alex

Hi and thanks for your post

Yes, the users wil be creating in Word and then pasting into Access

What is the best way for them to be able to do this - Is it possible to
change settings in Word so that Ascii 34 is ued?

From Word help for "smart quotes":

To turn this feature on or off:

On the Tools menu, click AutoCorrect Options, and then click the
AutoFormat As
You Type tab.
Under Replace as you type, select or clear the "Straight quotes" with
"smart
quotes" check box.
Note You can find and replace all instances of single or double curly
quotes
with straight quotes in your document. To do this, clear the "Straight
quotes"
with "smart quotes" check box on the AutoFormat As You Type tab. On the
Edit
menu, click Replace. In both the Find what and Replace with boxes, type '
or
", and then click Find Next or Replace All.


If the users don't want to give up smart quotes in Word, you could run an
Update query updating the memo field to

Replace(Replace([memofield], Chr(147), Chr(34)),Chr(148), Chr(34))

John W. Vinson [MVP]