Acess Memo Fields

[Guest]

Are access memo fields the only control one could use if they wanted to
assocate records in a table with large amounts of text?

I have a database that tracks transaction specifics between the company and
customer. Sometimes, a particular account requires the generation of a letter
to be mailed to some place. I was considering using a memo field to allow the
user to type his/her letter, then build a report that would incorporate the
account info with the text that was generated...the only problem is the memo
field and its lack of word processor qualities....

Is a memo field the only way to go in this case? Am I completely on the
wrong path? Has any one else ever incorporated word processing in their
Access applications?

TIA

Antonio

 

[Allen Browne]

Yes: the memo is the field type to use where you want more than 255
characters in a field, so it makes sense to base your "letter" report on a
memo.

Access 2007 supports some formatting within a memo field. Previous versions
do not, though it is possible (with effort) to use a rich text control such
as this:
http://www.lebans.com/richtext.htm

 

[Arvin Meyer [MVP]]

You can associate Word documents with Access records simply by creating a
path to them. I wrote a database quite some time ago to facilitate this:

http://www.datastrat.com/Download/DocMgr_2K.zip

You can also output Access data to Word Bookmarks. A sample of that is:

http://www.datastrat.com/Code/WordMerge.txt

You can also use Automation to work with any other Office suite product.