Outlook表單筆記 ，Outlook custom form，好的參考網站

如何在custom form中使用Date/Time pick

• 在【設計表單】狀態下---將【控制工具箱】叫出來---在【控制工具箱】上click mouse右鍵---選自訂控制---勾選microsoft outlook date control & microsoft outlook time control。
  即可於【控制工具箱】使用此元件。

Search Google key word: 【outlook formula field】

公式參考:

某個欄位的公式

• "請假單 ( "+[請假人]+" 自 "+Str([FromDateTime])+" "+[假別] +" "+ Str( [day] ) +" 天 " +    Format(Str([time] ), "0.##" )+ " 時 )"
• Switch(FollowupDate - Date() < -5, "Very Overdue", FollowupDate - Date() < 0, "Overdue",
      FollowupDate - Date() < 6, "OK", True, "Future")
• Switch(Month(SomeDate) = 1, "Cold", Month(SomeDate) = 2, "Cold", Month(SomeDate) = 3, "Cold",
      Month(SomeDate) = 4, "Mild", Month(SomeDate) = 5, "Mild", Month(SomeDate) = 6, "Hot",
      Month(SomeDate) = 7, "Hot", Month(SomeDate) = 8, "Hot", Month(SomeDate) = 9, "Hot",
      Month(SomeDate) = 10, "Mild", Month(SomeDate) = 11, "Cold", True, "Cold")

好的網站：

http://www.outlook-tips.net/