Apart from the apostrophe, any other problem characters?

[XP]

Using Office 2003 and Windows XP;

I found out the hard way that adding an apostrophe in a text box causes an
error when writing to the table(s).

Has anyone had problems writing any other characters to text and/or memo
fields?

I am just trying to head this off at the pass. I only need the normal
English character set for this project; are there any other characters that
could cause a problem?

Thanks for your response.

 

[fredg]

Using Office 2003 and Windows XP;

I found out the hard way that adding an apostrophe in a text box causes an
error when writing to the table(s).

Has anyone had problems writing any other characters to text and/or memo
fields?

I am just trying to head this off at the pass. I only need the normal
English character set for this project; are there any other characters that
could cause a problem?

Thanks for your response.

That's strange. I write names like O'Connor, O'Brien to a table
without any problems, as well as using possessive and abbreviated
words such as Mary's, it's, and don't.

Perhaps it's your code syntax that is creating a difficulty.

If you are using ..... '" & [ControlName & "'" to read or concatenate
a value in a text field, simply use
""" & [ControlName] & """"
instead.

 

[XP]

In attempting to use your method, I get an immediate error:

Compile Error: Expected end of statement.

I seem to need the same number of double quotes at each end; but even then,
it still yields an error in writing to the table - unless I remove the ' .

I'm using a function to strip away the apostrophes. Any other ideas?

Using Office 2003 and Windows XP;

I found out the hard way that adding an apostrophe in a text box causes an
error when writing to the table(s).

Has anyone had problems writing any other characters to text and/or memo
fields?

I am just trying to head this off at the pass. I only need the normal
English character set for this project; are there any other characters that
could cause a problem?

Thanks for your response.

That's strange. I write names like O'Connor, O'Brien to a table
without any problems, as well as using possessive and abbreviated
words such as Mary's, it's, and don't.

Perhaps it's your code syntax that is creating a difficulty.

If you are using ..... '" & [ControlName & "'" to read or concatenate
a value in a text field, simply use
""" & [ControlName] & """"
instead.

 

[fredg]

In attempting to use your method, I get an immediate error:

Compile Error: Expected end of statement.

I seem to need the same number of double quotes at each end; but even then,
it still yields an error in writing to the table - unless I remove the ' .

I'm using a function to strip away the apostrophes. Any other ideas?

Using Office 2003 and Windows XP;

I found out the hard way that adding an apostrophe in a text box causes an
error when writing to the table(s).

Has anyone had problems writing any other characters to text and/or memo
fields?

I am just trying to head this off at the pass. I only need the normal
English character set for this project; are there any other characters that
could cause a problem?

Thanks for your response.

That's strange. I write names like O'Connor, O'Brien to a table
without any problems, as well as using possessive and abbreviated
words such as Mary's, it's, and don't.

Perhaps it's your code syntax that is creating a difficulty.

If you are using ..... '" & [ControlName & "'" to read or concatenate
a value in a text field, simply use
""" & [ControlName] & """"
instead.

Unless you post your actual code (copy and paste), I don't think
anyone is going to be able to give you more than the very basic
information I did in my previous reply. You're there and we're not.