All Forums >> [Scripting] >> ASP >> Formatting data BEING TAKEN FROM AN aCCESS DB Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
i'M TAKING DATA FROM AN ACCESS DATABASE AND POSTING IT TO AN ASP PAGE. tHE PROBLEM IS THE ONE OF THE FORMS IS A TEXTAREA FIELD THAT HOLDS UP TO 200 CHARACTERS. wHEN i COPY THE DATA BACK FROM THE ACCESS FILE IT MAKES THE PAGE TOTALLY SCREWED UP. iS THERE ANYWAY TO FORMAT THE THAT FIELD BEFORE IT IS GENERATED ON THE ASP PAGE. TY ALL. S73
Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
In other words when I take the information from the database and post it to my page within a table I want it to be x characters wide. Not one big long string that extends across the entire page. It looks like crap. Am I making sense? I'm new to this so correct me if I am. TY
Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
Andi, I tried that. The information will be inputted by a user (no more than 250 characters) upon submit it is sent to an Access Database and the user is sent to a following page. On that page they have the option of looking at the most recent submissions. By selecting "reports" the information in the Access DB is called to the page and displayed. My problem is when it is called it comes in a huge line totally screwing up the layouf of that *.asp page. I think that may be better. My *.htm page is set up like you said previously. TY
Posts: 95
Score: 0
Joined: 7/3/2001
From: USA
Status: offline
So if I understand this right, then you have an html page with a fixed width textarea field, that submits to an .asp page that writes to a db...then you want to be able to read and display the contents of the db, but the display is all horked up...so try bounding your displayed information in a table, and restrict the width of the table or cell...
ie: <table width=50%><tr><td> YOUR DATA HERE </td></tr></table>
Posts: 17
Score: 0
Joined: 6/27/2001
From: USA
Status: offline
~imav8n All true but I did that. I bounded that field just like that but it still doesn't work. I'm beginning to believe that I'll have to format the string before it submits to the asp page and writes to the DB. It is an Access DB. That is funny horked up and that is exactly the word. It spread the screen like a mile to the right. I'd like to have to text wrap at designated points like the 25 character or a blank character in or around that whichever comes first. What to do? TY Slayer73