Long Fill in

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kcholly - 07 Feb 2006 01:12 GMT

I have a form that the field I use to capture data is not large enough. I
remember seeing a web site that explained how to set it. Ex. like a police
report. Does anyone remember the web address.
Thanks

Reply to this Message

Doug Robbins - Word MVP - 07 Feb 2006 05:10 GMT

' Macro created 05/09/98 by Doug Robbins to insert long string into
FormField

'

FillText = "Your long string"

LenFillText = Len(FillText)

FirstBit = Left(FillText, 255)

If LenFillText > 255 Then

SecondBit = Mid(FillText, 256, LenFillText - 255)

ActiveDocument.FormFields("Text1").Result = FirstBit

Selection.GoTo What:=wdGoToBookmark, Name:="Text1"

ActiveDocument.Unprotect

Selection.InsertAfter SecondBit

ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True

Else

ActiveDocument.FormFields("Text1").Result = FillText

End If

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a form that the field I use to capture data is not large enough. I
>remember seeing a web site that explained how to set it. Ex. like a police
>report. Does anyone remember the web address.
> Thanks

Reply to this Message