Hope everyone is having a good Holiday....!!

I would like to open word via a modal button located on an Access Form.  We have an Electronic log which has inputs that occur during each shift.  On occasion we will have an event that requires a detailed account of what took place during a certain time period.  I don't want to use a memo Field because if you hit enter to go to next line....your done.  Besides, management would like a neatly typed doc, of course, retriveable also .  And............ Eye Candy also helps.    
Any Ideas..........

  

____________________________
C.......................

How about opening a form with a rich text box on it for your user input. When closed this could be saved uniquely (using datetime perhaps) with the name of the file saved to the db.

This can be later opened in Word if required.

Hope this helps

Dave

____________________________
While Breath.Count>0
       Live(gbRelax)
Wend

Hi,
I agree with Daves suggestion to use a RTB control.
But just to pick up on your comment "if you hit enter to go to next line....your done." I presume you mean that your users are tabbed into the next control instead of inserting a CR+LF into your Memo Field to move to a new line within that field. You can change this behavior to do what you want. Open the property pages for the control that you are using (presumably a TextBox) select the "Other" Tab, then change the property for "Enter Key Behaviour" from "Default" (which Tabs you to the next control in the Tab order) to the other choice in the drop-down list for that property, which is "New Line in Field"
Hope that helps for in the future where you may want Line Breaks in a Text or Memo Field.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.