Results 1 to 2 of 2
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    How to Drag and Drop a Label on a Form and Return the Location of the Label


    I have a report that uses a .png file for the Picture property and the report populates a number of labels' captions with data dynamically. The "Picture" is an multi-page, Application Form that I fill out with data from the database. In the PageHeader Format event, I change all the Labels Caption, Top, Left, and Width properties so that all the data lines up in the box specified for that data element. A corresponding control file contains a code for the data element itself and the location and width in inches. I convert these to twips and modify the control's characteristics. All this works fine except the user doesn't want to have to type in the Top, Left, and Width parameters in the Control File. She want to have the Application image on a Form and then drag and drop a control onto the form where she wants the data. Any suggestions on how to accomplish this using Access and VBA?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I have not tried it but Paul's site has a drag example, towards the bottom of the page.
    http://baldyweb.com/ChrisOSamples.htm

    Why not use your If page of pages Then statement to hard code the twips?

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

Similar Threads

  1. Replies: 1
    Last Post: 09-11-2013, 01:22 PM
  2. Drag and drop images into form
    By togo in forum Access
    Replies: 7
    Last Post: 11-05-2012, 08:51 AM
  3. How to rotate a label on an Access form.
    By dougie in forum Queries
    Replies: 2
    Last Post: 07-03-2012, 11:45 PM
  4. Form label in a report
    By SFC in forum Reports
    Replies: 10
    Last Post: 10-27-2011, 05:42 PM
  5. Replies: 9
    Last Post: 05-30-2011, 12:08 PM

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