专家坐堂-如何让动态表的合计自动居中Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

\'窗口表头设置.表中自动生成合计

Tables("月租收费_Table1").SetHeaderRowHeight(0,25,40)

Tables("月租收费_Table1").AddNew(10)

With Tables("月租收费_Table1")

.Cols("缴费_月租_缴费月数").GrandTotal = True

.Cols("缴费_月租_缴费金额").GrandTotal = True

.GrandTotal = True

End With

\'打开目录树.下拉选项\'

e.Form.Controls("Table1").Table.Cols("车牌号码").DropForm = "车牌目录树"

e.Form.Controls("Table1").Table.Cols("缴费_月租_起计日期").UsetBuildInEditor = True

e.Form.Controls("Table1").Table.Cols("缴费_月租_止计日期").UsetBuildInEditor = True

e.Form.Controls("lry").text = User.name

\'以这代码为准:

Dim yzdh As WinForm.TextBox = e.Form.Controls("dh")\'dh是单号控件

Dim di As String = yzdh.Value \'di单号控件中的变量

Dim d As Date = Date.Today

Dim y As Integer = d.Year

Dim m As Integer = d.Month

Dim Days As Integer = Date.DaysInMonth(y,m)

Dim fd As Date = New Date(y,m,1) \'获得该月的第一天

Dim ld As Date = New Date(y,m,Days) \'获得该月的最后一天

Dim bh As String = "yz" & "-" & Format(d,"yyyyMM") & "-" \'生成编号的前缀

Dim max As String

Dim idx As Integer

Dim flt As String

flt = "[前缀] = \'yz\' And [日期] >= #" & fd & "# And [日期] <= #" & ld & "#"

max = DataTables("缴费情况").Compute("Max(单号)",flt) \'取得该月的相同工程代码的最大单据编号

If max > "" Then \'如果存在最大单据编号

idx = CInt(max.Substring(10,4)) + 1 \'获得最大单据编号的后四位顺序号,并加1

Else

idx = 1 \'否则顺序号等于1

End If

di = bh & Format(idx,"0000")

yzdh.Value = di

如何让左下角的合计及自动统计的数字居中。