CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Preserving paragraph breaks in access memo field

Print topic Send  topic

Author Message
Rob E.
Posted: 05/02/2002, 7:28 AM

Based on an earlier thread, I've found that one way to preserve paragraph breaks in an Access memo field is to add <br> tags as needed within Access and then to select html text for the field within CC. This works well as far as it goes. It's certainly an improvement over no paragraph breaks.

However, I also intend to generate PDF database reports generated directly from Access. Having those <br> tags certainly seems like it'll pose a problem when I do so.

Is there another work around that'll work well in CC without requiring that I mess with the original Access memo fields?

(Another suggestion from the tread -- using a before show event in CC that inserts a <br> tag every 40 characters -- won't work for me since I need the breaks in specific, arbitrary locations.)

Thanks!
Rob
Tony M
Posted: 05/02/2002, 12:59 PM

Rob
How about...

1 - Copy file that's being converted to .pdf
2 - "search and replace" <br> in copied file with whatever is required for .pdf
3 - Convert copied file to .pdf

...just a thought
Petr
Posted: 05/02/2002, 2:02 PM

I use fldmemo=replace(fldmemo,vbCRLF,"<br>") in the Before Show Event of the form. Than I print to PDF.
Rob E.
Posted: 05/02/2002, 2:44 PM

Thanks Tony and Petr for your suggestions. Both solve the problem but Petr's is especially useful for me since I don't have to enter the <br>'s within Access in the first place. A great solution. I appreciate it.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.