Access MVP (2010-2015)
You import a spreadsheet and you noticed in some of your fields you have a little box with a question mark in it (see image below). This is a Carriage Return (Alt+Enter in Excel).
To remove create an UPDATE query and run against the offending field…
UPDATE YourTable SET FieldContainingCarriageReturn = […]
5,760 total views
