How do I change an Access 2007 multivalued field separator from the default comma to a semicolon?
I have a table in Access 2007 that has a multivalved field. By default values listed in a multivalved field are separated by commas. I would like to change the default from a comma to a semicolon. How can this be done? The reason for wanting to change to a semicolon is that the data values contain embedded commas.