>Hi Edward.
>
>>>How do you display the year only of the date field on a FORM?
>>
>>Thisform.Textbox.Value=YEAR(table1.datefield)
>
>Yeah but ensure to set ReadOnly = .T. or Enabled = .F. or else ka-boom...maybe THISFORM.Label.Caption=ALLTRIM(STR(YEAR(table1.datefield))) also??
What is ka-boom? :). It can be edited, if necessary (it's 'value' not 'controlsource').
Edward Pikman
Independent Consultant