Newbie to store formatted text

[Theodore Bartley]

Hi, I want to set up a database to track progress of jobs. Clients and
their data, financial transactions, etc, all of which should be
straightforward, but the thing I'm not sure about is how to store a notes
page for each client. The notes need to be formattable and could run to a
page or two of A4. I guess this could be a link to a Word document, but how
is it done? And I would like the page to be modifiable from Access if
possible. Thanks. Theo

 

[Larry Daugherty]

Hi,

In your table design, change the Note field type from Text to Memo..

HTH

 

[Larry Daugherty]

I missed the bit about "formatted" in my preceding post. My carelessness.

You may already have a good grasp of the trade-offs. If formatting is
crucial, Automation to Word may be your best solution. If you want to have
the output modifiable from Access then I recommend storing and maintaining
the notes in Access. In other words, make all edits in Access and generate
a new Word document whenever you need it.

HTH