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 >--------------------------------------------------------------------- -- Dave Shaw Northwest Classics, Inc tel: 206-954-7526 fax: 206-625-1338 ------------------ 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 ---------------------------------------------------------------------
