Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Nov 2005
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vertical Combo Box (2000)

    Is it possible to rotate a combo box on a report so it is vertical instead of horizontal?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Vertical Combo Box (2000)

    Not that I know of, but I could be wrong.

    Anyway why do you want a ComboBox on a report, you cannot use it as a ComboBox on the report. Wouldn't a text box suffice.

  3. #3
    Lounger
    Join Date
    Nov 2005
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Combo Box (2000)

    The Report is linked to a Form that had a combo box in it. In order for the field in the Report to display the correct info I needed to make it a combo box.

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

    Re: Vertical Combo Box (2000)

    Do you mean that the text should be rotated by 90 degrees? That is not possible.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Vertical Combo Box (2000)

    Where have you been?

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Vertical Combo Box (2000)

    You don't need a ComboBox on the form. A text box will show what's in the form's ComboBox unless you wish to show the bound column instead of the displayed column. But then you can use the .Column(nn) variant of the form's ComboBox to show that in the text box on the report.

    Or don't I understand the question??

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

    Re: Vertical Combo Box (2000)

    I went out to dinner in a very nice restaurant with my 83 year old father and a friend of his. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  8. #8
    Lounger
    Join Date
    Nov 2005
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Combo Box (2000)

    For instance I was trying to display the Customer name (which shows up on my form, and is a combo box in the form) in a report, but instead of the name showing up in the report i was getting the ID#. Can you please explain more about the .Column(nn) variant. I am not familiar with this function.

    Thanks!

  9. #9
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Vertical Combo Box (2000)

    If your ComboBox name is Combo4 (I think it is named that) then if the customers name is the 1st column you can address that by:

    Forms![formname]!Combo4.Column(0) where (0) specifies the 1st column, (1) specifies the 2nd column, etc.

Posting Permissions

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