A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

field attributes and design



 
 
Thread Tools Display Modes
  #1  
Old August 19th, 2005, 05:26 PM
Joe Chromy, Jr
external usenet poster
 
Posts: n/a
Default field 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
  #2  
Old August 19th, 2005, 06:23 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

"Joe Chromy, Jr" wrote in
:


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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Making one field on a form dependent on another fields results? dawnykins Using Forms 30 November 4th, 2005 10:50 PM
2nd post Database design different attributes Burghew Database Design 1 March 10th, 2005 01:37 PM
New normalised table design question Liz James General Discussion 3 January 5th, 2005 08:01 PM
Must # of fields in the 2 tables in an Append Query be equal? CreativeImages Running & Setting Up Queries 3 October 1st, 2004 05:16 PM
Access Calendar lost General Discussion 2 July 7th, 2004 04:58 AM


All times are GMT +1. The time now is 09:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.