I need to change the fields so that Only the first letter of every word is in Caps.

Right now its all over the place. Some records are all lowercase, some are all uppercase, and some are mixed.

Thanks

Devin

under Text Format >> Title Case

Text Format does what it says: it formats the DISPLAY of the text, on a particular instance of a field, on a particular layout. It does not change the data itself. To do that, replace the field contents with a calculation =

Proper ( yourfield )

If this is a multi-user solution, script a loop instead, setting the field to the same calc. Backing up beforehand is strongly advised for both.

Text Format does what it says: it formats the DISPLAY of the text, on a particular instance of a field, on a particular layout. It does not change the data itself. To do that, replace the field contents with a calculation =

Proper ( yourfield )

If this is a multi-user solution, script a loop instead, setting the field to the same calc. Backing up beforehand is strongly advised for both.

Dam that was easy! I was looking all over!

Thanks

Devin