By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
463,141 Members | 579 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 463,141 IT Pros & Developers. It's quick & easy.

show multiple records in one form wihtout continuous or datasheet view

P: 6

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?

Sep 30 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,923
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:
Sep 30 '08 #2

P: 6
Thankyou so much, the MS KB article worked a treat!
Sep 30 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.