[AccessD] Setting a field in a report

On 10 Apr 2005 at 14:34, connie.kamrowski at agric.nsw.go wrote:

> 
> Ok I have done that and the field populates using the EndDate value . But
> the code crashes with a "you have entered a property which has no value"
> message. It does have a value because it is displaying it on the form
> 

Just looked at your original again:

> Dim MyEndDate as Date
> Dim End ReportDate as Date
> 
> MyEndDate = Year(Me!EndDate)
> EndReportDate = DateSerial(MyEndDate, 04,30)
> 

You need to Dim MyEndDate as Long, not as Date. (Year() returns a number, 
not a date)

-- 
Stuart