Type Mismatch

[Costefran]

Hello

Can anyone help

The following code is executed on an after update event on my form
Forms![Cost Authorisation Preparation Form]![Year of Applicaton] = Year(Now())
It was working fine and now I am getting a type mismatch message
The format of the [year of application] control on the form is set to text on the underlying table and I can only assume that trying to set the text control to year (now()) is the cause of the problem although I'm not sure how it worked beforeI really would like to keep the control set to text and it is used in other queries in my DB so perhaps I need to convert year now to a string?

Unless of course there is another reason

As usual any help would be appreciated
Thanks

 

[SkipVought]

Hi,

Maybe...

Forms![Cost Authorisation Preparation Form]![Year of Applicaton] = CStr(Year(Now))

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Costefran]

Many thanks

Have tried using this and get the same problem so if you have any other ideas then would appreciate it

 

[Costefran]

Dear skipvought

Have solved my problem using the following code

Me.Year_of_Applicaton = VBA.Year(Now())

Many thanks for your help

 

[PHV]

Seems like you have an object named Year ...