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

apostrophies in names

P: n/a
Hi,

I have a list box that show up all the owners I have in a table. When
I click on a name in the table it displays all their information. When
I try enter a owner name with an opostropy eg Tom O'Reilly I get a run
time error. 3077. Is there a special way of entering an apostropy in a
name without it returning a runtime error.
Regards,

Denis

Feb 7 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 7 Feb 2007 15:09:30 -0800, Denis wrote:
Hi,

I have a list box that show up all the owners I have in a table. When
I click on a name in the table it displays all their information. When
I try enter a owner name with an opostropy eg Tom O'Reilly I get a run
time error. 3077. Is there a special way of entering an apostropy in a
name without it returning a runtime error.

Regards,

Denis
The problem is not with the apostrophe in the name it's in the code
used to return the record.
If your code is like [LastName] = '" & [Lastname] & "'"
change it to:
[Lastname] = """ & [LastName] & """"

For clarity only that's
= " " " & [LastName] & " " " "

Of course change [LastName] to whatever your actual field name is.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Feb 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.