Results 1 to 4 of 4
  1. #1
    williamrh is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Posts
    2

    Display only a portion of bitmap attachment on a form


    I would like to only display a portion of an bitmap attachment. Say I have a 1700 x 2000 bitmap in an attachment field, but I only want to show a small portion of the bitmap, say between pixels (200, 300) to (250, 450). Basically, it's like cropping the bitmap in the display on the Form, but retaining the original full size in the attachment field. I can see how to set Picture Size Mode to "Clip" and Picture Alignment to Top Left, Top Right, Center, Bottom Left, or Bottom Right. I would like to set a custom alignment that is at a specific point in the bitmap. Does anyone know of a way to do this?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    I am not sure if it is possible or not. I have not tried to do it. If you are not finding the settings you need in Access you may need to create another file. I am sure there are ways you can do it programmatically by rendering a copy via vector orientation.

    If the form is large enough you could place the entire format on the form and place that object to the back, layer-wise. All the other controls would be on top and you could mask the area you do not want to see with some rectangles the same color as the form's background. That might hinder the performance of the form though, having a large file size object...

  3. #3
    williamrh is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Posts
    2
    Found a way to do it. I put the image into a subform. The entire image is visible in the subform, but on the parent form I only made the subform the size of the portion I want shown. I then created a control at the location I want displayed and then set the subform focus to that location.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Great! Thanks for posting your solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Bitmap image won't export to excel?
    By C6067 in forum Import/Export Data
    Replies: 2
    Last Post: 03-04-2013, 03:31 PM
  2. Formatting split form datasheet portion
    By SpaceEd in forum Forms
    Replies: 5
    Last Post: 10-19-2011, 11:40 AM
  3. Display pdf attachment in report
    By BrianPeerless in forum Reports
    Replies: 5
    Last Post: 05-05-2011, 12:18 PM
  4. Bitmap image
    By FJM in forum Access
    Replies: 1
    Last Post: 06-07-2010, 11:34 AM
  5. Replies: 0
    Last Post: 04-23-2009, 09:42 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