Recent content by gt324

Sorry if I have caused any confusion. It all turns out to be that I was not displaying the the full data that I had picked in a text box. Long names ( which coincidentally contained spaces and were on OneDrive) were truncated but the file picker was working fine all along. Graham

Thanks very much for that. I see now that the problem is not to do with OneDrive. Any path name that includes a space seems to be a problem. Actually I am not sure now whether the problem is that the file picker returns a truncated string or I am failing to to display the string properly in...

I am writing in vba for Access 2016 I have used FileDialog(msoFileDialogFilePicker) which works fine on files on my computer (Windows 10) but when I select a file from OneDrive, it just says the file is my OneDrive folder.:eek: I guess that it sees the OneDrive folder as one big file! Is there...