Commas instead of semicolons in MS Access lookup column -

I do not dare label myself as a programmer. But I'm running a storefront website. I want to label some of my products with several categories, including making a column in my MS Access database (called categories), which are separate categories for commas. I.e. "shirt, clothes, wearable, sports"

I've added a lookup column that fixes it and includes the categories I select for a particular product. The problem is that When I export my database in a txt file, excel file, etc. ... this column shows with semicolon! "Shirts; Clothes; Wearable; Game"

Now, I can replace all semicolons with commas in that column, but I hope MS Access is an easy way to do this. Maybe a setting I do not know?

Any help would be greatly appreciated!

Store a list of items in a field is a design error.

Instead, you should have a table that relates to your main table, and this product stores the ID (it records the product for a particular link) and a category per record . Your example data will look like this, say ProductID = 1:

 Product ID category 1 shirt 1 clothing 1 wearable 1 game 

In a web app, you will then display the results A multilevel list box (you add "multiple" tags inside your SELECT tag) You must redo the list to add SELECTED tags to the previously selected item.