show multiple records in one form wihtout continuous or datasheet view

[pipeme]

Hi

I am not terribly proficient in access coding so please excuse my ignorance if this is easier than what I think it will be!

I have a query which has 3 columns and varying amounts of records (depending on what criteria is chosen). I would like the data displayed on my form in a way so that the records are displayed in a single row, below is how I'd like it to be shown;

Column 1 : r1 r2 r3
Column 2 : r1 r2 r3
Column 3 : r1 r2 r3

I would like to have the above instead of the below method which is what would be shown if I select datasheet or continuous forms view;

Column 1: r1 - Column 2: r1 - Column 3: r1
Column 1: r2 - Column 2: r2 - Column 3: r2
Column 1: r3 - Column 2: r3 - Column 3: r3

Is there a way I can tell datasheet view to display that way or would I need to create a txtbox for each possible record and use code to manually enter the data?

Thanks

[puppydogbuddy]

See this thread

Transposing Rows And Columns

and especially this reference to the ms kb that is contained in the last post for the above link:

http://support.microsoft.com/?kbid=202176

[pipeme]

Thankyou so much, the MS KB article worked a treat!