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
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