Do you mean an "Instead Of" trigger?  I've read how to use these in order to be able to access the text column. 

I'm not sure how to access the text column in the inserted/deleted tables in an Insert trigger.    In any case, we would need to access the data during inserts AND updates since the purpose of our triggers is for auditing and the only way I've seen to do this is using an "Instead Of" trigger, which is more work.   I wouldn't mind the additional code involved if our Text fields were really necessary, but in most cases they aren't.  The only reason we have them is that people were lazy when creating some of our tables.