Trouble with Data entry with the name starting with O'B...

R

Rocky

Don't know where to look, but had this problem before. With names like
"O'Brien"? Getting a Syntax error #3077 ( Access database seems like it
doesn't like the apostrophe character ('). Any solution to this problem?
 
J

John W. Vinson

Don't know where to look, but had this problem before. With names like
"O'Brien"? Getting a Syntax error #3077 ( Access database seems like it
doesn't like the apostrophe character ('). Any solution to this problem?
Click to expand...

Use " as a delimiter in your query (which you dodn't choose to post...)
instead of '; or use Replace([namefield], "'", "''") to replace all
apostrophes with two consecutive apostrophes prior to inserting.
 
Top