I have two fields in my table where one updates the other. The first field (MonitorDate) has a date (mm/dd/yy) entered into it, the second field (ScheduledMonitor) I want to display the year only, six years forward from the first date entered. [Example: Field 1=05/15/95, Field 2=2001]. I have formated all my controls to "yyyy", no imput masks and have a macro that sets the date forward 6 years attached to the first field on the AfterUpdate Property. I also want the table to store this date in year only. My tables' field property is set to text, and the format is "yyyy". Right now when I enter my date in the first field, my second field shows -1. Any help would be greatly appreciated. Thank you in advance.

Several points you shouldn't store the results of a calculated expression, set the text box data type to date /time, set the format to YYYY,in the after update of field 1
Me.Field2=DateAdd("yy",6,[Field1]).
HTH

[This message has been edited by Rich (edited 05-11-2001).]