Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combo box row source (2002)

    Hi All, I have a combo box with the row source pointing to 3 differenct word documents (a value list). Rather that have the display show "M:miscellaneous stuffPATIENT SATISFACTION SURVEY report 1999.doc", i like the display to show "report 1999" (just a name and not the full path), for example. Is this possible? Thanks, Van

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

    Re: combo box row source (2002)

    You can set the Column Count property of the combo box to 2, and the Column Widths property to 0";1". Setting the width of the first column to 0 effectively hides it.
    The Row Source should look like

    "full path and filename 1","short name 1","full path and filename 2","short name 2","full path and filename 3","short name 3"

    The combo box and its dropdown list will display the short names, but the value of the combo box will be the full path and filename of the selected document.

    Note: it might be easier to create a small table with two fields (FullPath and ShortName), and use that as Row Source (with Row Source Type set to Table/Query)

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box row source (2002)

    Thanks Hans, that's worked a treat! cheers, Van

Posting Permissions

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