Help with long text field

[NadiaWilkes]

Hello, I am really stuck and hoping for help.


i have a database where there is a table that has only one field and it is where I am keeping a number of different paragraphs that are used on customer quotes. This field is long text as it gives the user the ability to bold underline and highlight etc.

on a form that is based on another table I have a combo box or list box, tried both. In the combo box I have it selecting text from the 1st table and then I want it to on select put the text into my long text field in that form which is where the quote itself is generated from. My issue is that using combo or list method for selection it will not show the field only the ID which is of no use. Presumably because it is long text. Can any one suggests how I can achieve this?

thanks in Advance, Nadia

[pbaldy]

What is your code? You probably just need to refer to the second column of the combo (zero based, so the second column is 1):

Me.ComboName.Column(1)