# Unwanted double spacing reading from Access DB

**URL:** https://forum.kirupa.com/t/unwanted-double-spacing-reading-from-access-db/228560
**Category:** Uncategorized
**Created:** [June 8, 2007, 9:43pm UTC](https://forum.kirupa.com/t/unwanted-double-spacing-reading-from-access-db/228560 "2007-06-08T21:43:51Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![dragonfly](https://avatars.discourse-cdn.com/v4/letter/d/8e8cbc/32.png) [@dragonfly](https://forum.kirupa.com/u/dragonfly)
#### Post date: [June 8, 2007, 9:43pm UTC](https://forum.kirupa.com/t/unwanted-double-spacing-reading-from-access-db/228560/1 "2007-06-08T21:43:51Z")

</div>

I’m loading text from an Access database using Zinc. In some of my db text fields i have a double space between paragraphs. However, when it loads in to flash, it displays as double-DOUBLE text?. Like this:

in db:

```auto
blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah blahblaksjdfl
lasfjdljfas lafjd. blalh blah blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh
blah blahblaksjdfl lasfjdljfas lafjd.

blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah blahblaksjdfl lasfjdljfas
lafjd. blalh blah blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah
blahblaksjdfl lasfjdljfas lafjd.

```

in flash:

```auto

blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah blahblaksjdfl lasfjdljfas
lafjd. blalh blah blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah
blahblaksjdfl lasfjdljfas lafjd.

blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah blahblaksjdfl lasfjdljfas
lafjd. blalh blah blalh blah blahblaksjdfl lasfjdljfas lafjd. blalh blah
blahblaksjdfl lasfjdljfas lafjd.

```

I seem to recall that I had this problem before and did this:

```auto
var newVar = oldVar.split("
").join("\r");

```

but that isn’t working now. Please help. Thanks!