Setting value for Textbox

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

How can I set the value of a textbox to be equal to one
month prior to the current month?

Thanks,
Ryan
 
-----Original Message-----
=DatePart("m",Date())-1
.
Click to expand...

That is almost what I need. The only thing is that I need
to be able to display this information as mm/yyyy. any
suggestions? When I change the format of the text button
to this the date come up as 01/1900 because it recognizes
the number 11 not the month November 2003

Thanks,
Ryan
 
Back
Top