You can display a value of a textbox control that is bound
to a date field several ways.
By far the simplest is in the properies window of the form
enter YYYY in the format property. This will do the job
You can also format the control with Format([Application
Date],"YYYY") either in the format property of in your
The 3rd way is: Year([Application Date]) which will also
have the same result.
The last 2 can also be applied to the Recourd Source if
the source is a query.
for the same>-----Original Message-----
>I have an application form that is used from year to yearis used. I have an>agencies.
>I want to create a label that displays the year the format the date field>unbound text box and I want to write code that will lookstrFund = "2001">on the form and bring back a label for the year.
>I think the code is something like this:
>If [Application Date] > 1/1/2001 and < 12/31/2001 thenthen strFund= "2002">else if [Applicaiton Date] > 1/1/2002 and < 12/31/2002Can you please help>
>I am not a programmer, please excuse any gross errors.>me? Thanks much!!!