Fields configured as either a text or memo data type in an Access table are typically handled in code -- if, that is, there's a need to handle them in code -- using string variables.
(If you want to see any of the following examples in action, drag and drop a button onto a test form and copy...