>Hi ,
> I have two problems now.
>
> Firstly ,I doubt if there is any command that can add/remove field in table during runtime ?
Look at the ALTER TABLE command in help. You can add or drop fields.
>
> Then ,I try to use subtran to remove chr(13) in memo field ,but fail.
>Code is here :
> StrA = chr(13)
> StrB = Chr(13) + Chr(13)
> StrC = Subtran(StrC ,StrA ,StrB)
>
> After process the code ,nothing happened. But it work fine if I define STRA and STRB as "ABCDE" or something like that .
>
> Can you give me some advise ?
StrC = STRTRAN(StrC, StrA, StrB)
>
> Thanx a lot !
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer