Re: multi line combo boxes

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

I was afraid of that (I didn;t notice that it only allowd 255 characters
until after my last post). Witht that said, does anyone have any suggestions
as to how I can give users the ability to chose from a number of different
memos?

"Rick Brandt" wrote:

> 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: OleDb Truncates Access Memo Field
    ... > I'm using the OleDbDataAdapater to Fill a DataSet using MS Access as the ... The select command includes a memo field in the result set. ... except only the first 255 characters of the memo ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Text box info on Form doesnt print all on Report
    ... truncating in the record source query. ... First([Your Memo Field]) to get more than 255 characters. ...
    (microsoft.public.access.forms)
  • TransferSpreadsheet still truncates the memo field
    ... I am trying to export a query result as a comma delimited text file on ... When I use the export wizard, it trims the memo field down to 256 ... fields are still exported up to 256 characters. ...
    (microsoft.public.access.externaldata)
  • 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)
  • Re: multi line combo boxes
    ... bumpmobile wrote: ... > 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)