Page 2 of 2 FirstFirst 12
Results 16 to 27 of 27
  1. #16
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521

    Perfac, is that real data in the picture? Not sure if you want it displayed online if so. A moderator can delete the picture if appropriate.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  2. #17
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,891
    ControlSource property can be an expression, examples:

    Code:
    =CurrentProject.Path & "\" & [fieldname] & ".jpg"
    
    ="\\servername\folder\" & [fieldname] & ".jpg"
    
    ="C:\folder\" & [fieldname] & ".jpg"
    This means can call a Function that returns a value for the image link.

    I have never used Picture property for dynamic display of images.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #18
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    June, thanks. Reportview does render a perfect image but only after displaying a distorted screen and one have to click a few places to get the whole page to display. Yes the form and the print do it right. We have high respect for Access and enjoy using it, it is great. For our own business it is not an issue, but if we can get that right for the third parties using our application of course it is better if I can get it right. If it can not be done, we need to know until then we try.

  4. #19
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    No Paul the info is fake, thank you.

  5. #20
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,972
    If it's fake, rather strange that you have exactly the same information on the contact page of your website .....
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #21
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,891
    Yes, I have encountered the image distortion on PrintPreview with jpg and gave up trying to rectify. Just tested with a png and it is not distorted.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #22
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Thanks for all the concerns and advice. The bank account number is fake. Over 4 year I am reckless with my phone number, but I did not receive one unwanted call yet. I will change it now.

    June it is good news. As I said we have hundreds of images, all saved PNG format, following Ridders's advice. If you managed that, so should we. I don't know what we can try or adjust but I will try today.

  8. #23
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,891
    Well, darn, decided to try jpg (correction, this is jpeg) next to png. Both are images created from the same source - a scan of my driver license. Both look exactly the same in PrintPreview, undistorted. Now looking at jpg created from camera, it is distorted.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #24
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Most of our images are downloaded from the internet. Logos of businesses and photos of them. The photos on the attachment here on top was done with a camera(Cell Phone). I will test what you found. Thanks

  10. #25
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,891
    I took that camera jpg and used MS Paint to resize from 965kb to 17kb. It now displays without distortion.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #26
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Thanks. We always resize or reshape with MS Paint. So I will reshape as you suggest and let you know.

  12. #27
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Thank you June, it works.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 03-22-2018, 12:02 PM
  2. Replies: 2
    Last Post: 03-14-2018, 11:10 AM
  3. Replies: 1
    Last Post: 12-26-2016, 08:57 AM
  4. Replies: 3
    Last Post: 07-13-2015, 12:07 PM
  5. Replies: 2
    Last Post: 10-10-2011, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums