Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Posts
    31

    Unanswered: Combobox listwidth problem

    Hi guys i have a problem on how to set the listwidth property in vba using MSAccess.

    I have here a sample of my codes

    Me.cboassortedcontrol.Visible = True
    Me.txtmailsearch.Visible = False
    Me.cboassortedcontrol.RowSourceType = "Table/Query"
    Me.cboassortedcontrol.RowSource = "SELECT Employee.Program FROM Employee GROUP BY Employee.Program ORDER BY Employee.Program"
    Me.cboassortedcontrol.ListWidth = 3

    Any reply would be much appreciated.
    Thanx in advance

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    In VBA, the ListWidth property must be specified in twips. There are 567 twips in a centimetre, 1440 twips in an inch.
    Have a nice day!

  3. #3
    Join Date
    Dec 2012
    Posts
    31
    Tnx a lot Sinndho
    This works fine..

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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