Number of characters in a field

message from Scott on 13 May 2004
I have a Memo field which I would like to convert to a
text field, in order to avoid database corruption, now is
there any way how I can get the number of characters I
have in each record of the Memo field using a query. ?
so that I will be able to narrow down the criteria to >
250, and I will update those records to include only 250
characters. ?

Thanks

Scott
 
Van T. Dinh replied to Scott on 14 May 2004
1. I don't seem to have database corruptions due to Memo Field so I am not
sure whether converting to Text Field will help. Certainly, it is more
efficient to retrieve Text Field.

SELECT *
FROM [YourTable]
WHERE Len([MemoField] > 250
 
Joseph Meehan replied to Van T. Dinh on 13 May 2004
Many people don't have problems with memo fields corrupting some (like
me) have and it is not pretty.

I should remember, but I don't recall what happens if you just convert
the field type.
 

Archived message: Number of characters in a field (Microsoft Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.