i have a reoccurring string in a field that needs to be removed. i'd like to use the vba replace function, but i don't know how to apply it to a field in a table. i need advice on how to call the function properly, or modify the function to work on the field set as control. here's what i do in my macro:
1) open table TABLE1
2) goto control FIELD1
3) RunCode Replace("[TABLE1].[FIELD1]", "String to remove", "", 1)
and, of course, i'm using the replace function defined in the faq. thanks -- jim
1) open table TABLE1
2) goto control FIELD1
3) RunCode Replace("[TABLE1].[FIELD1]", "String to remove", "", 1)
and, of course, i'm using the replace function defined in the faq. thanks -- jim
