how to get a Memo field a combo box

[G.Gerard]

Hello
Does anyone know how to get an entire memo field to be displayed in a combo
box drop down list?

Example - if the memo field contains the following :
This is a test to see if
all the text in this field can
be viewed in a combo box
drop down list

How would I enter all this text in the combo box so that when the drop down
list is opened, I see all
the text in the above paragraph and not just the first line of the
paragraph?
Thanks

G.Gerard

[Rick Brandt]

"G.Gerard" <gg*****@nbnet.nb.ca> wrote in message
news:hf*****************@ursa-nb00s0.nbnet.nb.ca...

Hello
Does anyone know how to get an entire memo field to be displayed in a combo
box drop down list?

Example - if the memo field contains the following :
This is a test to see if
all the text in this field can
be viewed in a combo box
drop down list

How would I enter all this text in the combo box so that when the drop down
list is opened, I see all
the text in the above paragraph and not just the first line of the
paragraph?

If you mean still on different lines, you can't. A ComboBox drop-list cannot be
made more than one line high per row. You could use a replace function to strip
out the line-feeds and see the entire text (providing you could make the
ListWidth wide enough).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Kinetic - Paul G]

hi
the idea of a combo box is to provide a quick list of alternatives. . hence
the single line display

however if you add the memo field as in . . .

combo_MEMO
contains
MM_KEY obvious key field . . field 0
MM_MEMO memo text field . . field 1

set bound col to 1 etc

create an unbound text box and set the control-source to

=combo_MEMO.Column(1)

this will display the whole memo for the chosen record

cheers
paul

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:bq*************@ID-98015.news.uni-berlin.de...

"G.Gerard" <gg*****@nbnet.nb.ca> wrote in message
news:hf*****************@ursa-nb00s0.nbnet.nb.ca...

Hello
Does anyone know how to get an entire memo field to be displayed in a combo box drop down list?

Example - if the memo field contains the following :
This is a test to see if
all the text in this field can
be viewed in a combo box
drop down list

How would I enter all this text in the combo box so that when the drop down list is opened, I see all
the text in the above paragraph and not just the first line of the
paragraph?
If you mean still on different lines, you can't. A ComboBox drop-list

cannot be made more than one line high per row. You could use a replace function to strip out the line-feeds and see the entire text (providing you could make the
ListWidth wide enough).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com