Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cannot produce List Box (2000)

    I am unable to produce a list box - Reason being l require a field called "comments", which is shown in the Field List and in the table.

    But when l click on the List Box wizard it is not shown , l am totally baffled.
    Any ideas?

    Justin.
    Attached Images Attached Images

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Cannot produce List Box (2000)

    Is your comment field a memo field?

    I found that a memo field was not offered, but was when I changed it back to text.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot produce List Box (2000)

    The List Box Wizard (and the Combo Box Wizard) don't show memo fields. This is because memo fields are meant to hold very long pieces of text - if you can fit everything in 255 characters or less, you should use a text field instead of a memo field. A list box cannot display that much text, so including a memo field in a list box doesn't make much sense.

    You can, however, include a memo field in the Row Source property of the list box by editing this property after the Wizard has finished. Click the builder button ... in the Row Source property to do so.

  4. #4
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot produce List Box (2000)

    Yes , the comment field is a memo.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •