Re: multi line combo boxes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

bumpmobile wrote:
> In Access 2003 I have created a combo box that is linked to a memo
> field (the data in the field is just an id number but a memo is
> visible). After I make the selecton, the whole memo is visible in
> the combo box (which is good), but while I making the selection the
> combo box only shows one line for each option (as wide as the combo
> box). How do I make the entie memo visible in order to select one of
> them? I hope this makes sense.

You can't. And if you investigate further you will find that even after making
the selection you are only getting the first 255 characters from your memo
field, not the entire thing. ListBoxes and ComboBoxes cannot display more than
this.

You can use DLookup() to retrieve the full Memo field into another TextBox after
making your selection.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: multi line combo boxes
    ... I was afraid of that (I didn;t notice that it only allowd 255 characters ... >> In Access 2003 I have created a combo box that is linked to a memo ... > the selection you are only getting the first 255 characters from your memo ... > You can use DLookupto retrieve the full Memo field into another TextBox after ...
    (microsoft.public.access.forms)
  • Re: How to convert/copy memo field to text ?
    ... suppose I have a select statement and am selecting desc which is memo ... can I use do while in the select statement in SQL2K to read all the ... > convert VFP memo type to SQL text type. ... >> this selection and copy to excel file. ...
    (microsoft.public.sqlserver.programming)
  • Newbie question about TMemo
    ... I'd like the Memo control on my app to act like the IE Address bar.. ... change the URL) but then if you click into the selection, ... when I slap a memo on a form I can get the Control-a ... the event handler and 'a' has a key code of 65--Ord--rather than ...
    (comp.lang.pascal.delphi.misc)
  • How do I print ONLY the first page of a 10 page memo?
    ... memo. ... The only selection in the printing page options are ... This problem cannot be fixed by defining or creating ... the print style menu. ...
    (microsoft.public.outlook.general)
  • ADODataset & Unicode Memo field
    ... I have one simple table with one field of memo type... ... I get string (string conversion instead of widestring) and the Unicode is ... Can anybody help how to retrieve the unicode memo data to delphi's unicode ...
    (borland.public.delphi.database.ado)