cubbycub
09-25-2007, 04:52 AM
Hello all :help
I have designed a Deilvery Note form (which will need to be used on both Word 2007 and 2003) where I have 10 text form fields that when they are exited are copied to a second sheet using.
Public Sub Copy1()
ActiveDocument.FormFields("Text1b").Result = ActiveDocument.FormFields("Text1").Result
End Sub
When the string gets too long i get an error
run time error '4609'
string too long.
Is there a neater way of doing this where I can have longer strings with formating.
I think I will also in time need to add a third sheet that the info will have to be copied to (customer copy, return copy, and file copy). so the whole 20 seperate macros will grow by another 10 and i understand that this will effect the document in that it will become slow to use? (just somthing i heard once).
Anyway any help would be very much appreciated.
I have designed a Deilvery Note form (which will need to be used on both Word 2007 and 2003) where I have 10 text form fields that when they are exited are copied to a second sheet using.
Public Sub Copy1()
ActiveDocument.FormFields("Text1b").Result = ActiveDocument.FormFields("Text1").Result
End Sub
When the string gets too long i get an error
run time error '4609'
string too long.
Is there a neater way of doing this where I can have longer strings with formating.
I think I will also in time need to add a third sheet that the info will have to be copied to (customer copy, return copy, and file copy). so the whole 20 seperate macros will grow by another 10 and i understand that this will effect the document in that it will become slow to use? (just somthing i heard once).
Anyway any help would be very much appreciated.