Apart from the apostrophe, any other problem characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
 
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?

fredg said:
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.
Click to expand...

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.
Click to expand...
 
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?

fredg said:
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.
Click to expand...

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.
Click to expand...
Click to expand...

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.
 
Back
Top