I have an unbound text box on my Access 2010 Form that has the default value of: =DateSerial(Year(Now()),Month(Now()),1)-1
This gives me the first day of the current month minus one...basically giving me the last day of the previous month. It is formatted as mm/dd/yyy. This shows up correctly...