Search results

The original source of the data is Excel where Alt Enter is used for line feeds to format data ondifferent lines within a cell When the Excel file was imported into an Access table the Alt Enter (CHR10) was converted to "CHR13 & CHR10" (CRLF) to maintain the proper multiple line formatting...

Thanks for your response The CHR13 and 10 characters are in the table field of a table because the text within it should be displayed on multiple lines but when this field is used in a query and output to a Word doc that I am building in VBA, Word sees these characters and interprets text...

I have data in a field in a table that has CHR13 and 10 hidden characters so that the multiple lines of text will be formatted correctly. this field is part of a query that is inserted in a Word document that I am creating from within the Access app using VBA. When the field from the query...