memo field - formatting

[ma50blue]

I am building a simple database (Access 2003) to store various types of
information from our 33 union contracts. I am putting together a table to
hold excerpts out of each contract relating to a variety of subjects we want
to capture. The language that I want to copy out of each contract is
contained in WORD documents, however, different people have put these
contracts together over time and each person seemed to have their own way of
formatting so there is a variety of different formatting techniques involved
(paragraphs, tabs, bullets, indentions, short tables, section titles, etc).
Whenever I copy this language from WORD into the memo field, the formatting
is either gone or ACCESS puts in odd characters in place of the WORD
formatting. I have to go in and manually take out tabs, returns, etc to get
it look more presentable. Is there any way to prevent this from happening
and copy the language in as is? I am a fairly new user and need some help.
Thanks

 

[akphidelt]

Im pretty sure it is not possible. The only way around it is to create like a
word object that pretty much shows the word document. But putting it in to a
memo field seems impossible to me... but who knows.

 

[John W. Vinson]

I am building a simple database (Access 2003) to store various types of
information from our 33 union contracts. I am putting together a table to
hold excerpts out of each contract relating to a variety of subjects we want
to capture. The language that I want to copy out of each contract is
contained in WORD documents, however, different people have put these
contracts together over time and each person seemed to have their own way of
formatting so there is a variety of different formatting techniques involved
(paragraphs, tabs, bullets, indentions, short tables, section titles, etc).
Whenever I copy this language from WORD into the memo field, the formatting
is either gone or ACCESS puts in odd characters in place of the WORD
formatting. I have to go in and manually take out tabs, returns, etc to get
it look more presentable. Is there any way to prevent this from happening
and copy the language in as is? I am a fairly new user and need some help.
Thanks

Access - versions before 2007 anyway - does not support "rich text format"
fields. You must either upgrade to 2007 or obtain a Rich Text Format control.

 

[ma50blue]

how do you go about obtaining a rich text format control? Is this some type
of add-in or do you have to actually code it using VBA or something like
this. If I need to put in code it may be too limiting for me. Are you
saying that Access 2007 would work fine without any extra work or coding?

Thanks for you help.

 

[Douglas J. Steele]

Stephen Lebans has a free RTF control available at
http://www.lebans.com/richtext.htm, or you can purchase one from FMS
http://www.fmsinc.com/MicrosoftAccess/memo.html

Access 2007 allows formatting of text, but I believe it's actually HTML, not
RTF.

 

[ma50blue]

If I upgraded to Access 2007, would that have the same functionality that I
would get with either product you mentioned previously. Also, is the rtf
only when you are typing and editing into a memo field or will it also work
when copying in sections of WORD documents into a memo field.

Thanks so much for your advice.

 

[Douglas J. Steele]

I'm afraid I don't know, as I've never felt a need to try.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

If I upgraded to Access 2007, would that have the same functionality that
I
would get with either product you mentioned previously. Also, is the rtf
only when you are typing and editing into a memo field or will it also
work
when copying in sections of WORD documents into a memo field.

Thanks so much for your advice.