In recent question experts-exchange on similar question for MS access report, I got the following solution to create numbered list from a field with string containing semicolon separated statements.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim arrRemarks() As String, strRemark As String
arrRemarks() = Split(Me.CollegeRemark, ";")
For i = 0 To UBound(arrRemarks)
strRemark = strRemark & Trim(i + 1) & ". " & Trim(arrRemarks(i)) & vbCrLf
Me.txtremark = strRemark
If intend to mail merge the field to MS word, is there a way to create such numbered list.
Can we write a similar code in VBA for MS word?