I am having to develop a database application for a local charity using MS Access 2000, having not used this application in a while my skills are a little rusty. Having now almost completed the database I am now in the process of getting rid of the odd bug I have encountered.

One of the problems is with one of my reports. I have created a report that allows the user to view all the records held on the database. On running the report although it's outputting the correct data it keeps producing odd blank pages and am a little puzzled why.

I was wondering whether anyone else had experienced similar problems and had any suggestions?

Gaz

__________________
Gaz

Your detail section and margins probably total more than your page width, or you may have a control that is extending past the page width settings in your Page Setup dialog box.

One way to check and see if it is an oversized control, set the properties for the controls to Border = Solid and then run the report and see if anything is pouring over to the second page.

Regards,

Beth M

Thanks so much. It was like you said one of my graphics on the report was spanning out of range.

Now that I have sorted that out my only other problem relates to the how the data is presented on the report. Is there a way to force a page break when a group of related information will not fit on the page as a group? and how can I force the report header to be output on the page when this happens?

Gaz

Gaz,

As you stated, you wish to use a page break and keep together a 'group'. So, in design view go to View > Sorting and Grouping and set a field to 'group'. in the bottom section of the dialog box, for Group Header and Group Footer say Yes. You also have the options to 'Group On' and 'Keep Together' Click Ok.

Back in the report design, click on the footer section and then open the properties box and tell it to Force New Page = After Section.

You can play with the settings and see what the different resluts are for each one.

Regarding the report header, place your header info in the Group Header, this way it will appear with each new group.

Regards,

Beth M

Thanks Beth you are a star :-)

Gaz

Thanks Gaz. But unfortunately I think I'm classified as a 'falling' star instead of 'shooting'! :0

Beth M

I am hoping you might be able to help me one final time. I feel quite silly really as it's the simple things in Access I have forgotten and can't seem to find answers for in the help files. Basically I have now completed the database, however I cannot recall how to set focus for bound text box when an event such as the ADD button is pressed. I have checked my tab order and all is correct yet after the Add button is pressed the cursor is not placed at the first entry point. Any ideas?

PS Beth you are a STAR is my books :-)

Gaz

You probably should have started another topic for this one, but after your command to do whatever, you would use:

me.[controlname].setfocus

Regards,

Beth M

Thanks for all your help

Gaz

It's been my pleasure!