469,889 Members | 1,257 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,889 developers. It's quick & easy.

how to get a Memo field a combo box

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
Nov 12 '05 #1
2 6307
"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
Nov 12 '05 #2
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kevin | last post: by
4 posts views Thread by steverossiter | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.