Subject Re: Closing an image on a form From Mervyn Bick <invalid@invalid.invalid> Date Mon, 3 May 2021 07:49:36 +0200 Newsgroups dbase.getting-started On 2021/05/03 04:06, roy price wrote: > Mervyn Bick Wrote: > > Hello Mervyn, > It seems that windows retains the "Date Taken" for some files (Images only?), but it is not normally visible unless selected (right click heading in Explorer). > So I used a program called DirectoryListPrint to list the directory where the images are, (including the "date taken") and spent a couple of hours editing the results for consistency, before writing a quick program to load the image dates into my table. > Also Libre Office's spreadsheet has an option to capitalise the first character of all words, so I'm considering using that function if I can download the text field, modify it and upload again. You don't need to use a Libre Office spreadsheet to capitalise the the first character of each word.  dBASE will do this for you in situ by using the function PROPER().  Code to do this was given on Saturday in the thread "Change Upper Case". You can either place the following code in a program using, obviously, the correct table and field names, or you can execute it line by line in the Command Panel. use whatever replace all fieldname with proper(fieldname) use If you only want to capitalise the first letter of the first word with the rest of the words in lowercase use whatever replace all fieldname with upper(substr(fieldname,1,1))+lower(substr(fieldname,2)) use Mervyn.