How to save the file name in text How do I preview in the report?
problem:
How to preview pictures in the report? The database table is placed in the following fields, student numbers, name, gender, picture path, as follows: 1002003001, Zhang San, male, 100/2003 / 1002003001.jpg. Now make a report, want to display the picture, because the picture path is the character type, so it is displayed 100/2003003001.jpg, how can I display the picture? The picture is below the 100/2003 / folder in the directory where the database is located.
Reply:
Place invisible TextBox in the report, display the path of the image file, then put a Picture control, write the code in the format event of the body.
Private sub main body _format (Cancel as integer, formatcount as integer) image40.picture = currentproject.path & "/" & photo .valueend Sub instance, please refer: http://access911.net/down/eg/report_picture.rar ( 41.9k)
