[dba-SQLServer] NVARCHAR turned into Text(255) in Access

I uploaded my billing database to SQL Server the other day.  The process
worked perfectly AFAICT, however SQL Server turned my memo field into a
nvarchar, which when linked back into ACCESS, was now being converted to a
TEXT(255).  Needless to say, this was not my intention, nor is it
acceptable.  Has anyone ever run into this?  Known solutions?
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com