Convert a memo field into a text field in access 2007?

I have a fairly large DB and would like to convert a memo field into a text field. However I think that some or a few records might hold more than 255 characters. Is there a query or report that will check?|||There's a simple way to check the size of a field.





Create a new query from the table in question.





Add the memo field to the design then create 2 new calculated fields next to it like this:





Data: Trim([MEMO_FIELD])


Length: len([Data])





The first extracts the data only and removes any padding that would make all the fields the same length.





The second then tells you the length of the data without padding.





View the query results and you'll see the length of the data in each. Sorting by the Length field will quickly show you if any fields contain over 255 characters.





Cheers!