Multiple columns - 3rd post...

I have a SPROC that returns any number of vehicle options for a specific
vehicle.
I want to display the information in a multi-column fashion like this...
4speed Auto Windows Floor mats
Radio Bucket Seats Wheels
NOT like this
4speed
Auto Windows
Floor mats
Radio
Bucket Seats
Wheels
Somone suggested using the Table control and to add a second detail row.
I tried that, but I must be doing something wrong... I just get the
same option repeated... like this...
4speed
4speed
Auto Windows
Auto Windows
Floor mats
Floor mats
Radio
Radio
Bucket Seats
Bucket Seats
Wheels
Wheels
Thanks in advance!Have you tried using the MATRIX feature?
Is there a MAX to how many features a vehicle can have?
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||sorry, missed that last question... no, there is no MAX
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||I did try that... didn't work...
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||Brian,
You could use a list and in the list arrange the textboxes however you
wanted them. You would just need to make sure you had enough boxes for the
vehicle options.
Not sure if this is the correct solution for what you need, but just another
idea.
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||Create a three column report, with a body so short it only holds the
one text box. Similar approach as would be used for mailing labels.|||I am trying this, but what happens is that I see Column2 and column3 to the
right of the first column, I place the text box in the first column, and
what I see in the out put is the very last option from my query and that is
it.
any ideas?
Thanks again!
"Parker" <psmith@.iquest.net> wrote in message
news:1128084282.571367.232050@.o13g2000cwo.googlegroups.com...
> Create a three column report, with a body so short it only holds the
> one text box. Similar approach as would be used for mailing labels.
>|||Modify your stored proc so that it returns a concatenated string wit
a carriage return after each third entry. Then display the result i
a text box and the text will wrap. The string should something lik
this
item1 & " " & item 2 & " " & item 3 & char(13
& char(10) & item4 ...
Most lilkely you will have to use a cursor to build the string an
also do some text manipulation to force column alignment