Hello,

What is the best way to handle notes on a form?

The DB is for recording Quotes and Orders taken over the phone.

Is it best to have a seperate table w/ a NotesType field so that all notes are stored in a central location? Or is it better to store notes for each quote/order in the Orders / Quotes table itself?

Also, if data is entered into these fields using subforms, is it possible to have the notes displayed outside of the subform in a box format, to allow plenty of typing room?

If anyone has a good example of a smart notes system implementaion, it would be very appreciated.

Thanks!

I would use a separate table since that allows you to have multiple notes per order. To enlarge a field for typing, use Shift-F2 to open the zoom box. If you don't want your users to have to remember that key combination, you can add code to the double click event of the notes field to provide a more intuitive interface.

Pat, as always... Thanks!!!

I'll look into the VBA behind the Shift-f2, and build a notes structure into a sample and post sometime soon.

(Hopefully I'll be able to post a decent working database in the next few days)

I forgot to post the code:

DoCmd.RunCommand acCmdZoomBox