New line characters in Access memo fields - possible?

Posted on 2004-10-15
Last Modified: 2013-12-24
New line characters in Access memo fields - possible?

I have an Access 2000 database containing some long Memo fields.

Does anyone know if and how it may be possible to embed characters into the Memo field to force a new line (i.e. effectively a new paragraph) when the Memo field is displayed by the FrontPage 2003 Database Results Wizard?

(In a similar way perhaps to the method one can use to insert extra spaces between sentences by embedding a series of   codes).

Thanks for any advice on this.  (I do not want to solve the problem by having several Memo fields replacing the single Memo field).
Question by:Jeeva
  • 3
  • 2
LVL 14

Expert Comment

ID: 12322933

This is the solution.  You put this code instead of the field name code after putting your DRW to Spooky Diet:

<%=Replace(FP_FieldVal(fp_rs," YourMemoFieldName" ),chr(10)," <br>" )%>


Author Comment

ID: 12323858
Thanks very much hhammash.  Excellent.  I accept your answer.  I figured out in the end, even though I didn't have a clue what Spooky Diet meant!

Now for a further 100 points, I imagine that I can use the same technique to replace any character
within the memo field by a break, not just replacing a new line character with a break.
If so, all I need to know is what the chr() value is for any particular character.  

Can you point me to a list somehwere of all the chr() values?  I particularly want the chr() value for the tilde symbol
(wavy line), which is sometimes above the hash symbol or number sign on keyboards.

Thanks if you can help with this as well.
LVL 14

Accepted Solution

hhammash earned 200 total points
ID: 12326100
Hi Jeeva,

Spooky Diet is:

The list of chr():


Author Comment

ID: 12326567
Thanks very much hhammash!  Jeeva.

For reasons I won't waste time explaining, I decided to represent new line characters in the Access database memo field not with the usual new line character chr(10), but with the ~ tilde (wavy line) symbol, and therefore to use the modified code <%=Replace(FP_FieldVal(fp_rs," YourMemoFieldName" ),chr(126)," <br>" )%> .  This works fine.

Previously I tried doing this with the hash (number sign) symbol #, using chr(35), (rather than with the tilde symbol) and although it did replace # symbols on display with a <br> as required, it had the unfortunate side effect also of changing some other characters within the memo field on display with disastrous results, such as creating hyperlinks within the displayed memo field text, and not showing the pound currency sign as such, but as its html code form.  Are you able to explain why the # sign caused so much havoc please?  Regards.  Jeeva
LVL 14

Expert Comment

ID: 12326627

Maybe because the "#" is used for hyplerlink bookmarks.

Nice approach Jeeva.


Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Web Developer 7 268
How to protect website documents without Windows Security 7 104
Collapseable list of URLs. 10 112
use of cookies and regulations 1 74
Now that Expression Web 4.0 ( is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following:…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: : Go t…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now