MS Access - Remove Enter Key from the data
Can anyone help me with the following problem?
I'm having trouble removing the Enter key (13 hex) in my data record.
Ex : I have a memo type field and the user will enter all the information
into this field with the Enter key(sometime) as below.
But I need to get the output in my file as line 1 line 2 line 3.
Mean without the Enter key, so my data won't go to the next line.
As I know, in MS Excel we can use the CLEAN command, but this function is
fail on MS Access.
If anyone has a solution, please email me to email@example.com
Any help greatly appreciated.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL