Results 1 to 3 of 3

Thread: combo box

  1. #1
    Join Date
    Jul 2003
    Posts
    81

    Exclamation Unanswered: combo box

    Guys I need Help??? I'm finishing a project with Access but I noticed that a combo box shows me the value I pick in lowercase instead of uppercase. What should I do?????

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Put a ">" symbol in the combo box's format property. That will force
    it to display in caps, however, your data will still be stored in lower case.
    To convert your data, add this line to the combo box's AfterUpdate
    event:

    Me!FieldName=Ucase(me!fieldname)

  3. #3
    Join Date
    Jul 2003
    Location
    india
    Posts
    1

    Talking

    Hi Try the following code
    write this code after the populating the combox.
    for i=0 to combo1.listcount-1
    s=combo1.list(i)
    combo1.removeitem i
    combo1.additem ucase(s),i
    next

Posting Permissions

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