Populate Report From Table

[chalupabatman]

I am wanting to have a "template" report for example called "_Template" that has the static text and beside the text have values that would be pulled from fields in the table, something like the below
First Name: tblInfo.firstname
Last Nane: tblInfo.lastname
Address: tblInfo.address
Phone: tblInfo.phone


And have that set-up in a rectangular "grid" format so that it would look similar to the below
1 2
3 4


5 6

And each # in the above would be populated with a different row in the table.

How would I go about setting this up?

[June7]

Pretty much the same way you build a form.

Set report RecordSource property. Put labels and textboxes on report and arrange them as you prefer. Set textbox ControlSource property to a field or expression. Use labels and or textboxes for the static text.

Where do those numbers come from - data in table?

[chalupabatman]

The numberrs waz just a layout example to show that I woudl expect 6 rows from the table per "page" on the report. I know that will be formatting I will need to set-up on the report itself, but was just for visualization.

I want the report to layout like this - AND each of the below would show data from a different row.
First Name: tblInfo.firstname First Name: tblInfo.firstname
Last Nane: tblInfo.lastname Last Nane: tblInfo.lastname
Address: tblInfo.address Address: tblInfo.address
Phone: tblInfo.phone Phone: tblInfo.phone

First Name: tblInfo.firstname First Name: tblInfo.firstname
Last Nane: tblInfo.lastname Last Nane: tblInfo.lastname
Address: tblInfo.address Address: tblInfo.address
Phone: tblInfo.phone Phone: tblInfo.phone

First Name: tblInfo.firstname First Name: tblInfo.firstname
Last Nane: tblInfo.lastname Last Nane: tblInfo.lastname
Address: tblInfo.address Address: tblInfo.address
Phone: tblInfo.phone Phone: tblInfo.phone

[June7]

Looks like you want a multi-column report snaking right then down.

[chalupabatman]

Yes - That is exactly what I Needed. Thank you for interpreting my insanity here.

[June7]

Access reports have that as a design feature.

[chalupabatman]

@June7 - I set the columns = 2 and Column Layout to Across then down - but I get an error of there is not enough horizontal space to display all the data.

Can I excuse my laymans terms "delete the fields", set-up the report like I want, then add them back in? That way I Get the exact layout I am after?

EDIT ---
I set it to show 2 columns, but it is only showing 1. And if I copy/paste the fields to show it on the same line twice, the data is duplicated, it does not iterate to the next record.

[June7]

According to your example, should be only four textboxes arranged vertically.

Delete textboxes? Sure. Not sure how that will help but go ahead and try.

Adjust column and margin spacing and see if that helps.

[chalupabatman]

Yes, it is 4 textboxes arranged Horizontal - 1 group of 4 in each number sequence is what I am after
1 2
3 4
5 6

I am only getting data output in 1, 3, and 5

[June7]

4 textboxes arranged vertical

[chalupabatman]

If I arrange them vertical same output. I would have data only in left column, never in the right.

[June7]

Then something else is wrong with the column settings because it works perfectly for me.

What is the column width?

[chalupabatman]

Column Spacing .25"
Column Size Width: 8.0833"

[June7]

Change the width to 3", not the full width of printing area.

[chalupabatman]

Changing column width to 3 still only populates the left column

And if it matters the field types are short text.