財務支票出票日期必須中文大寫。Access 2007 以 VBA 自訂函數 Udate() 即可自動轉換,套用於查詢/表單/報表,一次開發處處可用。
tblChecks,含欄位:付款人、付款帳號、收款人、金額 (Currency)、出票日期 (Date, 預設值 Date())。Udate 函數:Public Function Udate(mDATE As Date, mYMD As Integer) As String
' 用法: Udate(#1/2/2005#, i)
' i=1 → 貳零零伍 (年)
' i=2 → 零壹 (月)
' i=3 → 零貳 (日)
' i=0 → 貳零零伍年零壹月零貳日 (完整)
Dim i As Integer, iD As Integer
Dim strDT(2) As String, strS As String
Dim strD(0 To 9) As String * 1
strD(0) = "零": strD(1) = "壹": strD(2) = "貳": strD(3) = "三"
strD(4) = "肆": strD(5) = "伍": strD(6) = "陸": strD(7) = "柒"
strD(8) = "捌": strD(9) = "玖"
For i = mYMD + (mYMD <> 0) To mYMD + (mYMD <> 0) - (mYMD = 0) * 2
If i = 0 Then
iD = Year(mDATE)
strDT(i) = strD(iD \ 1000) & strD((iD \ 100) Mod 10) & strD((iD \ 10) Mod 10) & strD(iD Mod 10)
Else
If i = 1 Then iD = Month(mDATE) Else iD = Day(mDATE)
If iD > 9 Then strS = "拾" Else strS = ""
strDT(i) = strD(iD \ 10) & strS & strD(iD Mod 10)
If iD > 9 And iD Mod 10 = 0 Then strDT(i) = "零" & Left$(strDT(i), 2)
End If
Next
Select Case mYMD
Case 0: Udate = strDT(0) & "年" & strDT(1) & "月" & strDT(2) & "日"
Case Else: Udate = strDT(mYMD - 1)
End Select
End Function
qryChecksPrint,加入所需欄位,新增計算欄:大寫日期: Udate([出票日期], 0)。大寫日期 列印。擴充應用:同理可擴充金額大寫轉換函數,整合成完整支票列印模組。
關鍵字:列印、日期、中文大寫、VBA、支票、Access 2007