Type Mismatch

Hey All

Bran spankin' new to this forum. Have a question with regards to Access and Macros...

I have an Access frontend running with an SQL backend. Boss doesn't want me to step into VB much, wants me to handle everything in Macros.

I am trying to make a macro that prepends a date to a field in a form. Problem is that this field is already populated with text data, and date is in date format (Using Date() in the macro) I get a type mismatch error when I run the macro.

Here is the line...
Its a SetValue Action...

Date()+[Forms]![FindDataEdit_Changes].[Notes]

Note that the old notes are preserved and added to the back of the date. Like I said above, I get the error "Type Mismatch" with no error code.

Thanks in advance to any suggestions you may have to offer.

Dylan

Yes - you'll need to convert the date to a string first... I assume Access is similar to any other MS langauge, so check out the cstr() function. Or Google "convert string"

This did the trick, thank you (and sorry about the belated reply)