考試大編輯整理:在Access報(bào)表中實(shí)現(xiàn)圓角的矩形
下面的代碼可用于在報(bào)表實(shí)現(xiàn)圓角的矩形
調(diào)用方式:在報(bào)表的節(jié)的Format事件或頁(yè)的Page事件中調(diào)用
'Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
' RoundCornerBox 4000, 6000, 100, 200, 300, Me
'End Sub
原作者:未知
翻譯:tmtony(access/Office中國(guó))
創(chuàng)建一個(gè)新模塊,添加如下代碼
Sub RoundCornerBox( _
lngWidth As Long, _
lngHeight As Long, _
lngTop As Long, _
lngLeft As Long, _
lngRadius As Long, _
rptReport As Report)
Dim sngStart As Single
Dim sngEnd As Single
Dim dblPI As Double
dblPI = 3.14159265359
'左上角
sngStart = 2 * dblPI * 0.25 ' Start of pie slice.
sngEnd = 2 * dblPI * 0.5 ' End of pie slice.
rptReport.Circle (lngLeft + lngRadius, _
lngTop + lngRadius), _
lngRadius, vbBlue, sngStart, sngEnd
'上邊線條
下面的代碼可用于在報(bào)表實(shí)現(xiàn)圓角的矩形
調(diào)用方式:在報(bào)表的節(jié)的Format事件或頁(yè)的Page事件中調(diào)用
'Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
' RoundCornerBox 4000, 6000, 100, 200, 300, Me
'End Sub
原作者:未知
翻譯:tmtony(access/Office中國(guó))
創(chuàng)建一個(gè)新模塊,添加如下代碼
Sub RoundCornerBox( _
lngWidth As Long, _
lngHeight As Long, _
lngTop As Long, _
lngLeft As Long, _
lngRadius As Long, _
rptReport As Report)
Dim sngStart As Single
Dim sngEnd As Single
Dim dblPI As Double
dblPI = 3.14159265359
'左上角
sngStart = 2 * dblPI * 0.25 ' Start of pie slice.
sngEnd = 2 * dblPI * 0.5 ' End of pie slice.
rptReport.Circle (lngLeft + lngRadius, _
lngTop + lngRadius), _
lngRadius, vbBlue, sngStart, sngEnd
'上邊線條