Use of commas in form controls and tables

[Guest]

Using Office 2003 and Windows XP;

I have a field in which I would like to enter a comma to separate text,
however, this seems to cause issues in the db when trying to upload into a
table, or from a table into a multi-column listbox, etc.

How can this be done? or should I use semi-colons instead? What's the
practice out there? Also, what about memo fields where a user might enter a
lot of commas?

Your help much appreciated.

 

[Stalin]

Using Office 2003 and Windows XP;

I have a field in which I would like to enter a comma to separate text,
however, this seems to cause issues in the db when trying to upload into a
table, or from a table into a multi-column listbox, etc.

How can this be done? or should I use semi-colons instead? What's the
practice out there? Also, what about memo fields where a user might enter a
lot of commas?

Your help much appreciated.

Double quote strings

 

[John W. Vinson]

Using Office 2003 and Windows XP;

I have a field in which I would like to enter a comma to separate text,
however, this seems to cause issues in the db when trying to upload into a
table, or from a table into a multi-column listbox, etc.

How can this be done? or should I use semi-colons instead? What's the
practice out there? Also, what about memo fields where a user might enter a
lot of commas?

Your help much appreciated.

Please post some description of what you're doing and what problem the comma
is causing. There is NO reason that you need to avoid commas in a text or memo
field!

Perhaps you need to delimit the string you're inserting by quotemarks? Are you
entering data directly in a form control, directly into a table datasheet, in
a Query, or how?

John W. Vinson [MVP]