Fill page with blank field

[jca]

I developped a bill system for my company and everything is working great but now they want the access program to print the bill.

The bill is working good but doesn't look very good. My problem is that each bill doesn't have the same amount of item on them. So the bottom section, where the total is with the taxes and all, is keep being moved around. So what I want to do is expand the detail section to grow to a certain size each time which represent a certain amount of item.

I tried to put the total section in the bottom of the page section but what I get with this is a big blank gap between the total section and the item section. I want the item section to have extra blank field cause the item section is a grid. So it looks pretty ugly to have a grid then a blank space then the total section.

My idea is to check the recordcount of the bill before opening the report and create blank fields until I get the correct amount. But can I make a recordset and base a report on it or must I create a temp table ?

 

[Hayley Baxter]

Set the properties of the section to can grow = yes can shrink = yes.

Hay

 

[jca]

But it won't give me the empty grid look cause my grid is made with the border of each field

 

[azzurri]

Well certain format is best done through excel, this is something that dissappoint me.

 

[Rich]

Is this what you mean?

 

[azzurri]

Rich you are simply fantastic, you had solve my long time problem. Thanx also to those who intiated this thread.

 

[azzurri]

The annoying thing is that I had applied your code but it does not work, is the module need to be modified?

 

[cogent1]

I got this working, so the code is OK (on Access97 at least). You do have to modify the code to reflect your own field names in the detail section and make sure to include the Global variable in the module. Why isn't it working for you? What errors are you getting?