Solved

New line characters in Access memo fields - possible?

Posted on 2004-10-15
5
1,446 Views
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).
0
Comment
Question by:Jeeva
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:hhammash
ID: 12322933
Hi,

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>" )%>

Regards
hhammash
0
 

Author Comment

by:Jeeva
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.
0
 
LVL 14

Accepted Solution

by:
hhammash earned 200 total points
ID: 12326100
Hi Jeeva,

Spooky Diet is:
http://www.outfront.net/spooky/adv_drw_diet.htm

The list of chr():
http://www.asciitable.com/

Regards
hhammash
0
 

Author Comment

by:Jeeva
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
0
 
LVL 14

Expert Comment

by:hhammash
ID: 12326627
Hi,

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

Nice approach Jeeva.

hhammash
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Internet Explorer ignoring hyphens in html 1 90
Set up Wildfly 10 8 396
Ezidebit payment gateway 5 97
difference in Google dev tools and Firefox print. 12 55
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
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 automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
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…

777 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