>Is there a native foxpro function to accomplish this??

Yoiu can invoke the operating system FORMAT function with the RUN command; there is no native function or trivial API call that will do this for you rather than the OS format command. You can redirect the STDIN using pipes (or use an API call like CreateProcess() that allows you to redirect STDIN from the API call) to avoid having the user make responses to the FORMAT command.

You can use my API_APPRUN class (download from the Files Section) to run the FORMAT command and force VFP not to show a DOS window and to wait on the command to complete without permitting VFP to continue.