Copy & Paste Word to Access

K

Katherine R

How do I paste a numbered or bulleted list from Word to a field in Access
without losing the formatting? When I copy:

(a) First item on list
(b) Second item on list
(c) Third item on list

from Word and paste to Access, it becomes:

(a)â–¡First item on list
(b)â–¡Second item on list
(c)â–¡Third item on list

The spaces or tabs are being converted to a box.
 
F

Frank Marckus

It sounds like you need to store "rich text" as opposed to plain text which
is more usually associated with databases. To store and manipulate rich
text, you will need to use a memo field in the access table and a rich text
box control in the front end. (Assuming you want to edit data via an access
form). The rich text box control is called richtx32.ocx and you should be
able to find out how to use it fairly easily on the microsoft web site. When
you view rich text in an Access table it may appear as complete rubbish
because it is also storing all the instructions necessary to display
formatting such as font colour, bold, italic etc. However, when viewed via a
rich text box, everything can be edited as per MS Word.

I use the above method to create libraries of clauses complete with
formatting which can later be combined to produce Word documents.
 
K

Katherine R

Thanks for your help, Frank. I am using a memo field in the access table and
will check out the ms web site on the rich text box control.
 
Top