# Formatting text from ASP/Database

**URL:** <https://forum.kirupa.com/t/formatting-text-from-asp-database/85895>\
**Category:** flash\
**Created:** [April 8, 2005, 7:19am UTC](https://forum.kirupa.com/t/formatting-text-from-asp-database/85895 "2005-04-08T07:19:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![citizen\_erazed](https://avatars.discourse-cdn.com/v4/letter/c/439d5e/32.png) [@citizen\_erazed](https://forum.kirupa.com/u/citizen_erazed)\
**Post date:** [April 8, 2005, 7:19am UTC](https://forum.kirupa.com/t/formatting-text-from-asp-database/85895/1 "2005-04-08T07:19:22Z")

</div>

I am using ASP to get data from a MsAccess Database and pass it onto flash. The data is coming in fine and I can display it in a textBox if I set the text instances’ variable to what ever the variable name is from the asp, in this case “flcomment” and “fldate”. In the finished movie though I would like to have a scrolling html text box displaying news - so it needs to be formatted with a date and the comment underneath that, and so on.

Like I said above, I can display the text above fine, but when using [color=Blue]mainText.htmlText = this.flcomment;[/color] (_I’m using ‘this.’ because I am using loadVariables (“getnews.asp”, this, “POST”)_) the textbox displays “undefined”. I understand that the variable probably isn’t formatted to go into a texbox that way. I could use [color=Blue]mainText.variable = flcomment[/color] but the problem is that I want to format the text in the way I said above. Is there a way to convert that variable into a string?