In Access XP, I have a bound object frame where a user can drag and drop a file into it. The OLE type allowed is set to LINKED. I can drag and drop a file into it with no problems. I can get its application type (e.g. MS Word) and put it into a text field like this:

Me.txtApplication = Me.bofAttachment.Object.Application.Name

It gives me "Microsoft Word". That's great. But I cannot find the property that will give me this:

"C:\MyDirectory\MyFileName.doc"

Someone please finish this:

Me.txtFileName = Me.bofAttachment.________

Also, I set the the Display Type to ICON, but it's not giving me a Word Icon. Instead it insists on showing me a preview of the document as though I set Display to CONTENT. How can I get it to just show me an application icon when I drag and drop a file into it?

Thanks!



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division