symbols in fields/table

[SF]

Does access97 have a problem with symbols in fields in a
table: EX: Chuck's Food & Seafood Market's

It seems when I have apostrophe's or & symbol or other
symbols I sometimes have trouble in an update query from
that table. I went in and modified my names without the
apostrophes, etc. Although, they look better with them in
when I send out letters. Chucks Food And Seafood Markets
is to long and does not look as neat. Any suggestions???
Or answers??? thanks, SF

 

[John Vinson]

Does access97 have a problem with symbols in fields in a
table: EX: Chuck's Food & Seafood Market's

It seems when I have apostrophe's or & symbol or other
symbols I sometimes have trouble in an update query from
that table. I went in and modified my names without the
apostrophes, etc. Although, they look better with them in
when I send out letters. Chucks Food And Seafood Markets
is to long and does not look as neat. Any suggestions???
Or answers??? thanks, SF

The apostrophe only causes problems when you are trying to delimit a
string using ' as the string delimiter. What specifically are you
doing when you have a problem? If it's VBA code, consider using "
rather than ' to delimit your WHERE clause:

WHERE CompanyName = 'Chuck's Food'

will fail because the ' after Chuck is seen as the end of the string;
but

WHERE CompanyName = "Chuck's Food"

will work fine.