Multi-line "choices" in a combo box

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bigdaddrock
    New Member
    • May 2010
    • 67

    Multi-line "choices" in a combo box

    Working with an old database that had two fields: Address1 and Address2. This was to be used for two line street addresses. I prefer using the Ctrl+Enter feature to capture those rare two line addresses into a single record.
    However, when that field is used for "choices" in a Combo Box only one line appears!! Is there a way that I can direct the Row Source to display a "taller" row? I can control the Column Width of the Row Source Items, but want to control the Row Height to show both lines. Any suggestions?
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    If it was me, I'd
    1. Leave it as two fields
    2. If not already done, make a Query from your Table
    3. Add a Calculated Field to the Query using CombinedAddress : [Address1] & " " & Nz([Address2],"")
    4. Use the Query as the Combobox RowSource

    With the Calculated Field CombinedAddress as the bound field of the Combobox, the address will reflect
    both Address1 & Address2.

    Welcome to Bytes!

    Linq ;0)>

    Comment

    • Bigdaddrock
      New Member
      • May 2010
      • 67

      #3
      Thanks, that is the way I will go.

      Comment

      Working...