Memo fields in a combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

didi - 03 Apr 2008 10:07 GMT

Hi Guys,

I am currently trying to get a combo box to be filled with memo fields
coming from a query but whenever i do the wizard it will not see the
memo fields to be picked only integer files, is it not possible to get
a combo box filled with memo fields?

Didi

Reply to this Message

Allen Browne - 03 Apr 2008 10:33 GMT

Try creating a query that selects the fields you want.
Then set the combo's RowSource property to this query.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi Guys,
>
[quoted text clipped - 4 lines]
>
> Didi

Reply to this Message

John W. Vinson - 03 Apr 2008 18:25 GMT

> is it not possible to get
>a combo box filled with memo fields?

No. Bear in mind that a memo field could in principle contain a GIGABYTE of
data - an entire encyclopedia!

You can display the leftmost 255 characters of a memo field, but in general
one would not want to do so; a combo box doesn't allow multiple lines to be
displayed, just for one thing.

What are you trying to accomplish here? What will be done with this combo?

Signature

John W. Vinson [MVP]

Reply to this Message