M
magicdds-
I am merging a record with a lot of fields from Access into a letter in Word.
Some fields are PatientName, PatientAddress, PatientCity, etc. My question
has to do with one field that is a Memo field (because it contains more than
255 characters). The Memo field has data that has been concatinated in
Access, into the single Memo field. The data in this field might look like
this:
Diagnosis [Angle Classification] (Class II), Diagnosis [Arch Length
Discrepancy] (Mild maxillary crowding), Diagnosis [Arch Length Discrepancy]
(Moderate mandibular crowding),Treatment [Fixed Appliances] (Full maxillary
and mandibular braces), [Fixed Appliances] (Lingual Holding Arch), Treatment
[Removable Appliances] (Occipital pull headgear), Treatment [Removable
Appliances] (Biteplate), Treatment [Removable Appliances] (Mandibuar Retainer)
Once this data has been received by Word, I would like to break it up so
that it prints within the body of the letter to look like this:
Diagnosis: Angle Classification: Class II
Arch Length Discrepancy: Mild Maxillary Crowding
Moderate
mandibular crowding
Treatment: Fixed Appliances: Full maxillary and mandibular
braces
Lingual Holding
Arch
Removable Appliances: Occipital Pull Headgear
Biteplate
Retainer
Does anyone know how I can do this?
Thanks in advance for any help you can give me.
Mark Knoll
Some fields are PatientName, PatientAddress, PatientCity, etc. My question
has to do with one field that is a Memo field (because it contains more than
255 characters). The Memo field has data that has been concatinated in
Access, into the single Memo field. The data in this field might look like
this:
Diagnosis [Angle Classification] (Class II), Diagnosis [Arch Length
Discrepancy] (Mild maxillary crowding), Diagnosis [Arch Length Discrepancy]
(Moderate mandibular crowding),Treatment [Fixed Appliances] (Full maxillary
and mandibular braces), [Fixed Appliances] (Lingual Holding Arch), Treatment
[Removable Appliances] (Occipital pull headgear), Treatment [Removable
Appliances] (Biteplate), Treatment [Removable Appliances] (Mandibuar Retainer)
Once this data has been received by Word, I would like to break it up so
that it prints within the body of the letter to look like this:
Diagnosis: Angle Classification: Class II
Arch Length Discrepancy: Mild Maxillary Crowding
Moderate
mandibular crowding
Treatment: Fixed Appliances: Full maxillary and mandibular
braces
Lingual Holding
Arch
Removable Appliances: Occipital Pull Headgear
Biteplate
Retainer
Does anyone know how I can do this?
Thanks in advance for any help you can give me.
Mark Knoll