access form to word doc

John Sh

Active member
Local time
Tomorrow, 06:39
Joined
Feb 8, 2021
Messages
571
I have a couple of access forms that explain some operations to the user.
Is there a way to convert the form, with text, to a word document?
 
try googling DoCmd.OutputTo command to output your form into pdf, text, etc.
 
try googling DoCmd.OutputTo command to output your form into pdf, text, etc.

Thanks. Is there a comprehensive list of vba commands that can be downloaded?
That would save my time and yours.
 
As I'm sure you're aware, a PDF file will replicate the original layout but is read only.
Although these can be opened in Word, usually this is done using a Web browser or Acrobat Reader.

A text file output will be editable but have no formatting.

However, you can also export to rich text format (RTF) which may be more appropriate if you want to open Word and allow further editing.
Unlike PDF, it won't replicate the format of the original precisely, but it may be good enough for your purposes.
If not, then you can use Word automation from Access. Its a lot more powerful but also much more complex to set up
 
Last edited:
Here is another question. When you make this Word copy of the document in question, what will it have to do? If the answer is "be read by the user" but NOTHING ELSE, take a screen-shot of it and save it as a JPG or WMF, then import it to Word as a picture.
 
try googling DoCmd.OutputTo command to output your form into pdf, text, etc.

Thanks. Is there a comprehensive list of vba commands that can be downloaded?
That would save my time and yours.
Why not create Report based on the Form
 
If you use the built in windows snipping tool for screen shots, then you don't need to save the file, you can choose copy from the menu and paste directly into word. Also, prior to pasting into word, you can use things like the highlighting or pen tool to circle or add yellow highlight to a part of the screen shot that you would want the user to be aware of like pointing out a particular text box or button to be clicked on.
 

Users who are viewing this thread

Back
Top Bottom