Inserting Columns into Reports

V

Varne

Hi!

I have a one column table.

Col1
1
2
3
4
5


Now I want to create report (Not the auto one). Excectly the same as the
table. So I have to insert the box Col1 onto the blank report in design mode.
But how to do it? I see text box, combo and all the stuff but not something
to insert Col1!

Can someone show please?

Thank You.
 
G

Golfinray

When you build a report from scratch, not using the wizard, you have to set
the controlsource of each textbox, listbox, or combo box. The control souce
should look like:
=[yourtable].[your field] or possibly =([yourtable].[yourfield])
 
V

Varne

Hi!

Sorry for replying late.

Say I inserted a Blank Report. Access does not prompt for any.

Then I insert a text box under the detail bar in the design mode.

Then in the property window and in the data control source section I write
what you have given =[Tab].[Col1]

It appears in the text box.

But when switched to report view #Name appears.

Why?

Thanks.



Golfinray said:
When you build a report from scratch, not using the wizard, you have to set
the controlsource of each textbox, listbox, or combo box. The control souce
should look like:
=[yourtable].[your field] or possibly =([yourtable].[yourfield])

Varne said:
Hi!

I have a one column table.

Col1
1
2
3
4
5


Now I want to create report (Not the auto one). Excectly the same as the
table. So I have to insert the box Col1 onto the blank report in design mode.
But how to do it? I see text box, combo and all the stuff but not something
to insert Col1!

Can someone show please?

Thank You.
 
L

Larry Linson

Set your Table (you could also use a Query) as the Record Source of the
Report (Data tab in its properties sheet). For the Text Box in the Detail
Section, select the Column you wish to see as the Control Source (Data tab
in the properties sheet).

Just as a matter of interest, with your one-column table, what do you find
wrong with using the auto-report as a beginning? If you don't like the
formatting, you can open it in design view and modify it. You don't _have_
to, but just wondering.

Larry Linson
Microsoft Office Access MVP


Varne said:
Hi!

Sorry for replying late.

Say I inserted a Blank Report. Access does not prompt for any.

Then I insert a text box under the detail bar in the design mode.

Then in the property window and in the data control source section I write
what you have given =[Tab].[Col1]

It appears in the text box.

But when switched to report view #Name appears.

Why?

Thanks.



Golfinray said:
When you build a report from scratch, not using the wizard, you have to
set
the controlsource of each textbox, listbox, or combo box. The control
souce
should look like:
=[yourtable].[your field] or possibly =([yourtable].[yourfield])

Varne said:
Hi!

I have a one column table.

Col1
1
2
3
4
5


Now I want to create report (Not the auto one). Excectly the same as
the
table. So I have to insert the box Col1 onto the blank report in design
mode.
But how to do it? I see text box, combo and all the stuff but not
something
to insert Col1!

Can someone show please?

Thank You.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top