Mark01

<div>
Thank you, John. I simply want to eliminate the blank lines in a text box because I use paragraph styles in another app to control the space between lines.
</div>


<div>
Ok.. thought you might needed something else
</div>


<div>
<div class="content wysiwyg-content fr-view">
I am trying to use the code shown below in the AfterUpdate event of a text box to remove extra lines, but I get a compile error (syntax error). Please help.<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w19/1559156/test_050221.mdb" rel="ugc">test_050221.mdb</a><br>Source of code:<br>https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other-mso_2007/how-can-i-replace-carriage-returns-in-access-2007/286313e9-fb6f-e011-8dfc-68b599b31bf5<br><br><pre><code class="code-1 nolinks" id="code-10-29214922-1"><span>Replace([Author],Chr(10),Chr(13) &amp; Chr(10))</span>
</code></pre>
</div>
</div>


test_050221.mdb


I am trying to use the code shown below in the AfterUpdate event of a text box to remove extra lines, but I get a compile error (syntax error). Please help.
test_050221.mdb
Source of code:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other-mso_2007/how-can-i-replace-carriage-returns-in-access-2007/286313e9-fb6f-e011-8dfc-68b599b31bf5
Replace([Author],Chr(10),Chr(13) & Chr(10))

Access VBA - Syntax error

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.