Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    change text box to list box (97)

    I have a database created by someone else, with about 3,000 records. I would like to make one of the text fields into a list box and was wondering if there was any quick way to do that. I used a separate table as the row source and got it all set up, but now when you go to that field in each record it says "the value you entered isn't valid for this field." I can update it by clicking okay to get rid of the message and then highlighting the list box choice again. But I don't want to do that for 3,000 records. Any suggestions?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: change text box to list box (97)

    I don't understand why you want to change a textbox that's already populated to a listbox. ListBoxes are used to display choices and allow a selection, they aren't really meant to display selected values and it requires code to force a listbox to show the existing selection. You might be better off using a combobox, which will display the bound value and also dropdown a list.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: change text box to list box (97)

    Sorry! I meant combo box. It is changed to a combo box and I do get that error message. I've entered the choices exactly as they are already in the field.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: change text box to list box (97)

    Check order of fields in the row source of the combobox.
    If it is a table or a query, the fields are numbered form 1 to x.
    Then check the Bound column property of the combobox in the data tab.
    There will be a number in it witch is the number of the field in the row source. Are these two fields from the Row source and the Control source the same type ?
    Francois

  5. #5
    Star Lounger
    Join Date
    Feb 2003
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: change text box to list box (97)

    I checked it and had to change the bound column number and it worked! Thank you.

Posting Permissions

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