Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    47

    Unanswered: ActiveX Control UpDown

    Strangest thing... I have a number of UpDown controls on a form. When I retrieve data to my form, one (only one) of my UpDown controls moves to the upper left corner of my form. I tried setting the position of the control in my VBA (i.e. Me.control.Top = x, and Me.control.Left = y) but it continues to move. I've never come across this before. Does anyone have a solution to this problem?

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183

    ActiveX Control UpDown

    Read the current position value of the control, modify that value before setting it back to the control.

    Code:
    x = Me.Control.Top
    x = x+(0.25*1440) ' increase the top value by quarter of an inch.
    Me.Control.Top = x
    When you read the current position value of the control it gives the measurement in twips (1 inch = 1440 twips).

    On the control's Top Property value shown is in inches (or the measurement applicable to the regional setting), but you cannot use that value in VBA directly. It has to be in twips.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    May 2011
    Posts
    47

    Access

    Thanks so much. That worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •