Previously using Access 2003 now using 2007 for the first time - was using a text field for paths to images for displaying on forms, now I see there are attachment fields that seem to be for images. Question is how do I convert the text field into an attachment? Or should I even be trying?
attachment fields
- Thread starter Jyan
- Start date
SteveSchapel
Registered User.
- Local time
- Today, 22:41
- Joined
- Apr 29, 2010
- Messages
- 242
Jyan,
No, Attachment data type fields are not really for images, in the sense you are asking. They are for storing attached files (of any type), but this won't work well for the display of images. I recommend that you continue with the practice of using a text field to hold the path/file name of the image. The cool thing with Access 2007 and Access 2010, though, is that the Image control for your forms and reports now has a Control Source property, which you can set directly to the name of this field with the image's path/name, so that makes it a lot easier to manage images compared with the old versions.
No, Attachment data type fields are not really for images, in the sense you are asking. They are for storing attached files (of any type), but this won't work well for the display of images. I recommend that you continue with the practice of using a text field to hold the path/file name of the image. The cool thing with Access 2007 and Access 2010, though, is that the Image control for your forms and reports now has a Control Source property, which you can set directly to the name of this field with the image's path/name, so that makes it a lot easier to manage images compared with the old versions.
