Son/Daughter Report

[bigbadbess24]

Sorry Pat. We were on the same topic I just figure I ask him a quick question

 

[TanisAgain]

You will probably need mailmerge for that. Have a look at the help files or on this forum. Incidentally you need and 's' at the end of son/daughter. like sons/daughters. Not plural but possessive. Also listed is spelt incorrectly, lsited. Just a typo I expect.

David

 

[bigbadbess24]

Thank Tanis for the spelling correction. I will look into the mailmerge

 

[Rich]

The field is set to text and not memo

 

[bigbadbess24]

Which field?

 

[Rod D]

Hi Bess

If you change the label that contains the body of the letter to a text box and set the control source to the following, you should not have to do a mail merge, which would avoid another layer of complexity ...

="Due to the change in your " & iif([Sex]="M","Sons","Daughters") & " schedule, there is a change in the required textbook(s). Therefore, we request that you go to your textbook supplier with this letter and obtain and/or return the book listed below. If a course has been added it is essential that you obtain the textbook(s) as soon as possible. Since. without these books your " & iif([Sex]="M","Sons","Daughters") & " academic performance will be severely hindered. Thank you for your attention in this matter."

If you exceed the limit of characters in the Control Source, break the letter into more text boxes (1 per paragraph say) and go from there.

Hope I have not confused / de-railed the thread...

Regards
Rod

 

[bigbadbess24]

That worked prefectly!!!
Thanks a lot!