Compare two memo fields using a macro

zinrey

New member
Local time
Today, 06:33
Joined
Apr 19, 2012
Messages
5
I would like to write a macro in Access 2010 that can compare two memo fields (field and [old].field) and determine if any changes has been made.

To determine if a text field have been changed I can used the 'updated' operator:

if (updated([field]) then
.....
endif

but this doesn't work with memo fields. Anyone got any idea how I can approach this?

Thanks
 

Users who are viewing this thread

Back
Top Bottom