Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Resizing code128 barcode using cold fusion 14 176
What xml editor to use. 8 98
Problem to Popup 37 128
Is there any way to delete a Google Maps label? 7 9
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) 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 reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

828 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