Take a look at Afields() in the help...I think this will do the trick.
>I have a lookup table with 27 records and 71 fields per record.
>65 of those fields are MEMO fields containing static text.
>I need to update each memo field to remove junk (carridge returns and line feeds) from the end of each memo.
>
>Is there a way I can access the content of the memo fields by number instead of name?
>I'd like to do something like....
>
>
>SCAN
> FOR I = 6 TO 71
> REPLACE FIELD(I) WITH CleanMemo(Field(I))
> ENDFOR
>ENDSCAN
>
>
>So if Field(6) contains
>
>"Mary had a little lamb.$%$%"
>
>where $ represents CHR(10)
>and % represents CHR(13)
>
>CleanMemo(Field(6)) would return
>
>"Mary had a little lamb."
>
>
>All I can get so far if that Field(I) returns the field name, but I can't get the field contents.
>
>Rick