Showing results for 
Search instead for 
Do you mean 

Change format to Initial Caps

Copper Contributor
Posts: 27
Country: USA

Change format to Initial Caps

[ Edited ]

When our database was set up, most fields were created as character. I would like to change some of the fields to initial cap, but I get a warning that the change could create a loss of data & cannot be undone..Then the following fields would be reset: Default Value, Field Format, Use Drop Down List (do I want to continue).....Well, yikes, that message scares me so  I won't do anything. Is there a another way, or safe way to test the change? (besides making a copy of the database?)


Thanks, Judy

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Change format to Initial Caps

Since the change would be 'live' in your database and there isn't an 'undo' button, the best option for testing the change would be to create a copy of the database and apply the change to the copy.  Of course you could make a backup of the database, apply the change, and then restore the backup if the results weren't as expected - but I prefer using a copy of the database to test. 

Greg Martin