apostrophies in names

[Denis]

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

[fredg]

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