Is it possible to use the snip tool and past it in a text/memo field?

[davedinger]

So I have been working on a database that has a table named TblCallLog, with a long text field named Notes.
I use that table on a form named FrmNewCall that has the Notes field on it.

The basic premise of the form is when a person calls in the user can enter notes about the call. Everything works great, but I would like to enhance the notes field so the user can take a snip of what they are seeing on another program screen using windows snip tool and paste it in to the notes field along with text.

is it possible?
if so how an Will the clips massively increase the data size?

[Micron]

AFAIK, Snip tool is an image capture. There is no way to get the text from a picture - short of scanning with a scanner capable of OCR. Nor can you put a picture in a long text field in Access, so I'd say no. Can they not copy as text from the source and then paste into your notes field?

[CJ_London]

I seem to recall many years ago that it had been done - but don't think you would be able to copy/paste anyway and don't know if you could display the image. Basically you loaded the memo field with binary data from a bmp file. As far as size is concerned, probably will cause bloat - it won't be any smaller than the file

Google et/al don't seem to return old stuff these days, but found this link

https://www.vbforums.com/showthread....o-HDD-RESOLVED

this is similar
http://www.vb-helper.com/howto_store...access_db.html

given the age it will be a rtf style memo field, not the html format used today, but you are welcome to try

personally I would not store images in your db anyway. store them in a specified folder with a specified name - perhaps PK of the memo record. if you combined that with a time value as well you could have multiple images. Then your app simply looks in the folder for any files with the PK reference and displays them. You wouldn't even need a separate table to store filenames/paths but might want to add a 'has images' boolean field so the app doesn't needlessly search for images if there aren't any.

The trick will be pasting the image to access to then save to disk - this link might help
https://groups.google.com/g/microsof...v2d1f0mY?pli=1

but then
https://answers.microsoft.com/en-us/...5-f49a2c3ad2a4