Yeah. Ignore what I said, Dave's solution is much, much simpler. on 3/12/01 2:22 PM, Dave Shaw at [EMAIL PROTECTED] wrote: > Colin's got the right idea, working with the calculated Replace > function, but I would add that in FMP 5 there is a text function > called Proper(text) that changes the first character of each word in > the field "text" to upper case and the others to lower case. > >> In our old database, people had entered name and addresses sometimes >> in all caps. When I merged the data into ebase that formatting >> remained. >> >> When I print a letter from ebase using the merge fields for name and >> address, those all cap names and addresses come through. I >> understand in the labels format ebase is set to do this and that's >> fine but not in a letter. >> >> Is there someway I can change this in a batch rather than going >> through each record and using Format - Style - Title case? >> >> I tried viewing the data as a table thinking I could use the shift >> key to select more than one name and address and change them in >> batches. This didn't work. Is there a way to select more than one >> field at a time to do this kind of batch change? >> >> I'm using ebase 103 with Filemaker Pro 5 on a PC. >> >> Ileen Weber >> Pilchuck Aududon >> Everett, WA >> >> >> ------------------ Reminder to each recipient: To change your list >> account preferences, go to >> http://email.sparklist.com/scripts/lyris.pl?enter=support and enter >> the email address you used to subscribe to the ebase support list:: >> [EMAIL PROTECTED] >> >> To unsubscribe send a blank email to [EMAIL PROTECTED] >> --------------------------------------------------------------------- >> ebase - Relationship Management for Nonprofits, http://www.ebase.org >> --------------------------------------------------------------------- ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
