>>>How do you display the year only of the date field on a FORM?
>>
>>Thisform.Textbox.Value=YEAR(table1.datefield)
>---
>Hi Edward
>I have a value field on the form called txtyear.. It looks
>like 01/01/98. In the properties, where do I put:
>Thisform.Textbox.Value=YEAR(table1.datefield)?
>I would like txtyear to display like: 1998
>thanks
***Form.Refresh (or some other place fired each time your change record)
Thisform.txtYear.Value=YEAR(table1.datefield)
Edward Pikman
Independent Consultant