Thanks for your reply. I wasn't sure how to do the custom format but the
second option you gave me worked great. But how can I show the previous
year's quarter. I have two unbound text boxes on my form where I enter two
date periods. If the user enters 3/2010 into the second text box, then the
report will show Q1 Total for 2010 in one column but then I have another
column on the report (from expression in query) that is the previous year's
quarter. I want the report's unbound box to show this. I hope I explained
this okay???

Thanks!!!


Marshall Barton wrote:
I have two things that I’m trying to do in an unbound text box in my report.
I have this =Format([Forms]![frmVariance]![txtMo2],"q""Qtr""yyyy") which
returns “1QTR2010” but I want it to look like “Qtr 1 2010”. I tried this
“Qtr” “q” "yyyy" but Access changed it back to "q""Qtr""yyyy".

I also need the same thing for the previous year’s quarter like “Qtr 1 2009”.

You do not need to use Format function to do that. Just set
the text box to =[Forms]![frmVariance]![txtMo2]
and then set the text box's Format property to a custom
format like:
"Qtr" q yyyy

If you must use the Format function, I think it should be:
=Format([Forms]![frmVariance]![txtMo2],"""Qtr"" q yyyy")


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201005/1