G
Guest
I have a report that has a blank page before every new entry... it's driving
me nuts!
Is there a way of getting rid of it?
me nuts!
Is there a way of getting rid of it?
G
Guest
Use the "on no data" event procedure and you can get rid of that problem by
only displaying a msgbox that there is no data for the report or nothing.
Simply open the report in design view, on reports properties and go to
"Event" tab. then write the event procedure as below: -
Private Sub Report_NoData(Cancel As Integer)
On Error GoTo error_Report_NoData
MsgBox "There is no data for the desired report."
error_Report_NoData:
MsgBox Err.Description
Exit Sub
End Sub
only displaying a msgbox that there is no data for the report or nothing.
Simply open the report in design view, on reports properties and go to
"Event" tab. then write the event procedure as below: -
Private Sub Report_NoData(Cancel As Integer)
On Error GoTo error_Report_NoData
MsgBox "There is no data for the desired report."
error_Report_NoData:
MsgBox Err.Description
Exit Sub
End Sub
J
Joan Wild
Check the properties for the section, specifically the 'Force New page'
property on the format tab.
property on the format tab.
G
Guest
Where would I enter this?
I tired to insert it under "On Open" but it wouldn't work.
I tired to insert it under "On Open" but it wouldn't work.
G
Guest
I couldn't see a 'force new page' property...
Under format I have
- Caption
- Auto resize
- Auto center
- Page header
- Page footer
- Grp keep together
- Border style
- Control box
- Min max buttons
- Close button
- Width
- Picture
- Picture type
- Picture size mode
- Picture alignment
- Picture tiling
- Picture pages
- Grid X
- Grid Y
- Layout for print
- Palette source
- Orientation
- Moveable
Under format I have
- Caption
- Auto resize
- Auto center
- Page header
- Page footer
- Grp keep together
- Border style
- Control box
- Min max buttons
- Close button
- Width
- Picture
- Picture type
- Picture size mode
- Picture alignment
- Picture tiling
- Picture pages
- Grid X
- Grid Y
- Layout for print
- Palette source
- Orientation
- Moveable
G
Guest
Never mind, I fiddled round with it today and used a page break (which I
didn't know existed in Access before) so it works fine now!
Thanks
didn't know existed in Access before) so it works fine now!
Thanks
G
Guest
Dear Mr. Kat,
Just open the report in design view, then do as followings:-
1. Right Click on the blank area (shaded area, other than report area) of
the report by scrolling the horizontal scroll bar to downwards.
2. Select the "Properties".
3. The report property window will be opened.
a. You can open this property window by double clicking on the shaded
area.
4. On 3rd tab (Event), you will find the following:-
a. On Open
b. On Close
c. On Activate
d. On Deactivate
e. On No Data (Thats what, you are looking for...)
f. On Page
h. On error
5. Click the drop down menu corrospondant to "On No Data" and select [Event
Procedure].
6. Then click on the right side button shaping "...".
7. The VB Editor will be opened and write the script as i send to you before.
ALI
MS Access Developer
Just open the report in design view, then do as followings:-
1. Right Click on the blank area (shaded area, other than report area) of
the report by scrolling the horizontal scroll bar to downwards.
2. Select the "Properties".
3. The report property window will be opened.
a. You can open this property window by double clicking on the shaded
area.
4. On 3rd tab (Event), you will find the following:-
a. On Open
b. On Close
c. On Activate
d. On Deactivate
e. On No Data (Thats what, you are looking for...)
f. On Page
h. On error
5. Click the drop down menu corrospondant to "On No Data" and select [Event
Procedure].
6. Then click on the right side button shaping "...".
7. The VB Editor will be opened and write the script as i send to you before.
ALI
MS Access Developer