I have a form where a user checks a check box for months desired. The check boxes are named January...December. I need these boxes to return the first day of that month for future shipping. For example November should return November 1, 2005 while February should return February 1, 2006. I thought I could use something like: If Me.January.Value = True Then [Forms]![frmShippingCalendar][txtJanuary].Value = But from there I am not sure what date function/format to use. Ultimately, this will be used to populate a shipping calendar report.