Hi,

I was using a Append Only Memo Field in Access 2007 to show Column History for "Comments".



However, I have now converted the back-end to SQL Server 2008 whilst the Front-end is still Access 2007. Since I have done this, the field that shows the column history for "Comments" does not work anymore, it shows "#Error"

This is the control source used in the form:
Code:
=ColumnHistory([RecordSource],"Comments","[Asset_No]=""" &  Nz([Asset_No],0) & """")
It was working before the conversion.

The column "Comments" is set to nvarchar(MAX) in SQL Server.

I'm not really sure what needs to be done, I would appreciate all the help.

This has happened to all the columnhistory fields.

Thanks