I have a form that contains a textbox for notes. I want to add the option to select from a list of "canned" notes, so that similar notes don't have to be repeatedly typed in. The problem is that the majority of these notes are larger than 255 chars, so they need to be of the memo type.

Access tells me that I can't use a combo box with a memo field. The way I envisioned this working is choosing a canned note from a dropdown menu, which then copies that text into the notes textbox. Is there another way I can go about doing this so that I can use the memo field?

Thanks.

I do this by adding an additional field that is the "display description" that can be used in a combo box. In the after update event, you can use VBA code to insert the memo field's data into the control on the form.

OK, so let me see if I understand. I will add a display description, which is a shortened version of the full note. This can be displayed in the combo box. When the user selects something from the combo box, it triggers code that looks for a match in the table?

So I will need to loop through all of the canned notes and find the one with the matching display description? Thanks for your help!

OK, I think I understand what you meant now. I have a combo box set up to display a short description of the full note. Once selected, I have a textbox that gets populated with the associated "full note". Thanks.

You're welcome!

Glad we could assist.

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/uarulez2.gif)