adding my emoji

[ECEK]

Is it possible to have an image for each person in my database and for that to be shown on a form. ie. so when that person opens the database their image is shown.

If you could point me in the right direction that would be great.

 

[arnelgp]

you can either use short text field or attachment field.

if attachment, you can just drop the attachment field to the form and it will show the image.

for short text, it must contain the path of the image.
you need to to add this field to the form and add an image control.
on the current event of the form, set the picture property of the image to the short text field (name).

 

[ECEK]

Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks

 

[theDBguy]

Thanks Arne. I researched myself and found the answer to use the attachment approach. Works a treat. Thanks

Hi. For emojis, it probably won't be a huge problem, but be aware that using Attachment fields for storing large files/images could easily balloon the size of your database file towards the file size limit of Access, which could affect your database's performance.