Replace squares on a multie value field.

[aerosmith]

I have a field that has many records. in which there are squares instead of commas


Is there query or command i can try and have them replaced.

 

[Rabbie]

This can indicate you have used an invalid character

 

[WayneRyan]

AeroSmith,

Use an update query and update to:

Replace([YourField], vbTab, ",")

That assumes that the "unprintable" characters are tabs.
They might be vbCr (Carriage-Return).

To experiment, add a new column to a regular Select query:

NewColumn: Replace([YourField], vbTab, ",")

hth,
Wayne

 

[aerosmith]

That worked, thankS!!