No spaces between lines ?

[SpookiePower]

I have made a form where the user can enter how many
different items a customer have bought, as you can see
in this picture :
www.activewebsite.dk/pic/fak01.jpg

And the report looks like this :
www.activewebsite.dk/pic/fak02.jpg

My comboboxes on my form holds different items,
that the customer can buy. But if the customer does
not buy things from all the comboboxes, there will
be spaces between the lines on the report. How can
I remove these lines and put the other lines togehter
under each other ?

This is how I have made the report.
www.activewebsite.dk/fak03.jpg
But I guess that this is not the right way to do it, if I want
to remove the line-spaces.

 

[nthompson]

Have you got 'CanShrink' set to 'Yes' on both the detail section of the
report and the controls that display the text?

Nick

 

[SpookiePower]

Have you got 'CanShrink' set to 'Yes' on both the detail section of the
report and the controls that display the text?

Nick

I have nothing in my detail section. If I put this
www.activewebsite.dk/pic/fak03.jpg
in my detail section, the result will be displayed 3 times.
I don't know why it repeat it self.

I have insted put it in the page header, but this section
have not any CanShrink function.

 

[Duane Hookom]

I'm not sure why you don't bind your form and report to normalized tables.
What you are doing is very unconventional. Can you share something about
your data?

 

[SpookiePower]

I'm not sure why you don't bind your form and report to normalized tables. What you are doing is very unconventional. Can you
share something about your data?

I don't understand what you mean about bind my form and report to
normalized tables ?

The comboboxes gets some data from a tabel and the the user
enters how many items that is bought. The result from the comboboxes
and textboxes is then transfered to the report.

Can it be done easier, that the way I did it ?

 

[Duane Hookom]

Open the Northwind (or almost any other sample MDB) and you will find that
forms and reports have record sources of tables or queries. When values in
the tables are updated via the form with bound controls, the changes are
saved in the table(s). The reports display the values stored in the tables.

 

[SpookiePower]

Open the Northwind (or almost any other sample MDB) and you will find that forms and reports have record sources of tables or
queries. When values in the tables are updated via the form with bound controls, the changes are saved in the table(s). The
reports display the values stored in the tables.

Ok, I thnik you want me to put the data from the from, into a
table and then in to the report ?

I was thinking about doing that, but I have no need to save the data
for later use in a table. So I did it whit out using a table. But maybe
I should try it.

 

[BruceM]

You can enter data into an unbound form, then use the form as the source for
a report. You seem to have done that, but you haven't provided enough
information for anybody to know why everything showed up three times. If
each control on the form has exactly one corresponding text box on the
report it should work, but I can't imagine why you want to do it this way.

 

[SpookiePower]

If each control on the form has exactly one corresponding text box on the report it should work, but I can't imagine why you want
to do it this way.

Yes, that is how I did it. But how can it else be done ? If I have 5 textboxes
on a form that I put different data into, them I guess I must have 5 textboxes
on the report to recive the data. But I guess it can be done in another way.

 

[BruceM]

You can store the data in a table, then bind the report to the table and the
text boxes to fields. It seems you want to use Access to generate one-time
only reports, after which your only record is the paper copy. That's the
part I don't understand. Who not just use Word, or maybe Excel?

 

[SpookiePower]

You can store the data in a table, then bind the report to the table and the text boxes to fields. It seems you want to use
Access to generate one-time only reports, after which your only record is the paper copy. That's the part I don't understand.
Who not just use Word, or maybe Excel?

It's true that I only need the paper copy, and I don't need to
save the data in a tabel for later use. The user want it that way.
On my report I only need the name and adresse of the custemor
and then to calculate some numbers that the user enter on the form.
That's it.

I'm using access because I'm doing alot of other stuff with my
custemors, that only access can do. So I don't want to use excel
or word.