Setting value for Textbox

R

Ryan

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

Thanks,
Ryan
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Query from Form 8
Differentiating between displayed field value and stored field val 2
Read From Table and Write to Table As Well 2
Dependant textbox format 3
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Calculation 6
One TextBox Not Bound to Table 3
ControlTip Text 3

Top