Re: [AccessDevelopers] SPECIAL CHARACTER

Mon, 28 Nov 2005 04:22:04 -0800

You could also try using Chr(34)
 
If you give us your SQL statement I can show you how to use it.

Anil Kumar <[EMAIL PROTECTED]> wrote:
hi,
 
1. Double Quotes
    if u're using double quotes in a string, u've to use this special character 2 times(immediately) to appear  as a character.
 
eg. ur o/p :  I am a proud "INDIAN"
to get the above o/p, u should give the string like
           msgbox "I'm a proud ""INDIAN""  "
 
2. Single QUotes
 
if u're using single quotes inside a string, there's no problem occurs. but if u're using single quotes outside a string, from that character Access VBA will take it as a comment.
 
hope that ur problem solved.
 

brij <[EMAIL PROTECTED]> wrote:
Hello to all friends
 
here i want to know some thing about
special character
like ' ".
when i try to insert this character i got error
what would i do to avoid this type of errors ?
 
what this character are called ?
 
brij here


SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.


Please zip all files prior to uploading to Files section.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to