 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / August 2005field attributes and design
Afternoon everyone! I am at a loss right now and hopeful someone can help me in this news group. I have created an access db and various tables. I need to copy and paste information from a web site (press releases) into a long field in this access db.... When I do this the formatting attributes change to a straight text string (paragraph formats and carriage returns are removed) upon saving the change. Is there a way I can change the field attributes so that the field can retain the basic layout and formatting so it is easier to read for the user? Also - related - can an ACCESS field retain/read HTML or SHTML code? Bravejoe "That's my opinion. I could be wrong." Dennis Miller "It Doesn't Matter!" Bravejoe remove the "t1","us" and replace "com" with "net" from my email address to reply privately. "There's fodder for the cannons and the guilty ones can all sleep safely." Andy Partridge XTC > Is there a way I can change the field attributes so that the field can > retain the basic layout and formatting so it is easier to read for the > user? In a word, no. You can download a rich-text control that will save and reproduce text formatting -- try looking at Steve Lebans's site first. A normal memo field and text box control should at least maintain paragraph formatting from a web page: unless the page bas been created by one of these bone-headed, lame-brained morons for whom standards is just a difficult question in spelling-B's, and who think they are clever to use <br> tags instead of <p>. > Also - related - can an ACCESS field retain/read HTML or SHTML code? If you can be bothered to access the page source and copy-and-paste that, then it will be remembered. It seems to me that it should be possible to automate a Web Browser control on an Access form to display it too; but bear in mind that any half-decent web page will be CSS-driven and you won't neccessarily have access to the CSS file unless you really go out of your way to get that. Best guess is to look at a Rich Text ActiveX control. Hope that helps Tim F |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.