Show records in a vertical list
If you have a table with a lot of columns sometimes it would be helpfull to show a single record vertically instead of horizontally, so you see more data of the single record at the same time.
Albert D. Kallal commented
You have options now to show records vertically. In fact you don’t even need a cross tab. The report wizard normally creating and displays a record “horizontal” or so called “tabular”
However you are free to choose “columnar” which is VERY confusing – since it results in a non-columnar format. I suggest you try the report wizard with columnar – since you don’t have to display each record as a rows, but can display each record like on a form as you are asking.
You might expand on what you are asking - but displaying a record vertically as you ask does not require a cross tab query.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Grover Park George commented
This can be done as a crosstab query. It is a design feature, not an application feature.
Please visit one of the many Access support sites where members offer specific suggestions about handling specific features such as this.