Use Word as template to edit Memo fields?!?!

[superman_stow]

Hi,

I am new to this site and it has helped me many of times. I am an amature database designer and not that great with VBA coding but will need it to do what I need to do.

Basically what I want is to, use Microsoft Word as my editor in Access for Memo fields.

I have a form that is used to create an order for certain materials that we use but the rich text editor in access 07 doesnt have enough flexibility as I hoped, (e.g No Spellcheck for Runtimes versions and no check boxes) therefore I was thinking it might be possible that when I create an order and fill out the details of what i need and it comes to the actual 'body' (memo field) of the order it will open a blank word document or template (depending on the order selected) that I can then import into Access after it has been filled out.

Similarly, I would like the same thing for when a letter is created and to typoe the letter you use Word and then it imports it back to access.[FONT=&quot][/FONT]

Is this possible?

If you need more information please ask me as I would love for this to work somehow.

Thanks in advance.

 

[DCrake]

Simple Software Solutions

Even if you succeed in using Work as described and copy the body of text back to a memo field in Access you will loose all the formatting, such as changes in font sizes, embolding, underlining, etc.

Regarding spell checking you can do that within Access

Dim strSpell
strSpell = Me.FieldToSpellCheck
If IsNull(Len(strSpell)) Or Len(strSpell) = 0 Then
Exit Sub
End If
With FieldToSpellCheck
.SetFocus
.SelStart = 0
.SelLength = Len(strSpell)
End With
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True