Results 1 to 11 of 11
  1. #1
    beckyd89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    6

    Combo Box, Not Showing All Options in Form View

    Hi,

    The database I am using was created by a colleague who has left the company.
    It is a huge database, used by many colleagues. A colleague tried to change the fields in a combo box, however they made an error and asked me to rectify it.
    I am not an Access expert, so I used an archived version and ensured the property details on the archived and current combo box were exactly the same.
    However, the combo box still does not work and I cannot seem to rectify it.

    As you can see from the image below in Form View, when I select option 2, it also selects option 1. If I type '2' into the box, it says it isn't an option to choose ...


    Click image for larger version. 

Name:	Access Issue.jpg 
Views:	12 
Size:	6.0 KB 
ID:	46785

    This is the information in 'Row Source' on the Property Sheet.
    1;">55% - Normal";2;"45-54% - Mild";3;"35-44% - Moderate";4;"<35% - Severe";"N/A";9;"Not known"
    It should look like this in Form View (taken from the archived database).
    Click image for larger version. 

Name:	Access Issue 1.jpg 
Views:	12 
Size:	13.8 KB 
ID:	46786
    I am hoping this is an easy fix! Thank you in advance.

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    That looks like the columns being displayed are not what you want to see.

    Can you post up a picture of the combo properties - importantly the widths property and the number of columns set.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    beckyd89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    6
    Thanks Minty. These are the properties - let me know if you require anything else?
    I've just tried adjusting number of columns to 1 and it now allows me to select all of the numbers in the form (yay!) however the wording is not visible.
    Click image for larger version. 

Name:	Access Issue 2.jpg 
Views:	12 
Size:	42.4 KB 
ID:	46787

  4. #4
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Hmmmmm that's a bit weird. Those settings look about right.

    Can you show us the Data tab please from the combo?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    beckyd89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    6
    Click image for larger version. 

Name:	Access Issue 3.JPG 
Views:	13 
Size:	31.6 KB 
ID:	46788
    This is the data tab. Thank you for looking at this.

  6. #6
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    That all looks as it should be.
    The critical points are that it's set to Value List, the value list is populated, you have 2 columns listed, the column widths look correct.

    It's possible the control is corrupt. I would suggest copy and paste the row source text into notepad or something similar.
    If you feel confident simply delete the control , save the form compact and repair the database- then recreate it.

    Otherwise try delete the row source and save the form - compact and repair the database.
    Go back to your form and paste back the row source.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    You missed Not Applicable which is 8.?

    Are the property pics from the archived DB or the current one?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    beckyd89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    6
    I noticed that 8 was missing in the code too, however this worked in the archived version ... I tried adding it in, but it didn't make a difference.
    The properties are taken from the current version, but the properties are identical in both versions.

  9. #9
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by beckyd89 View Post
    I noticed that 8 was missing in the code too, however this worked in the archived version ... I tried adding it in, but it didn't make a difference.
    The properties are taken from the current version, but the properties are identical in both versions.
    Perhaps corrupt as mentioned previously then.?
    I would only ever show the text, not the bound value, and would have used a table as well.

    Do you have any recent backups, or is the archived version all you have.?
    Can your colleague remember what they did to get you in this quandry?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  10. #10
    beckyd89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    6
    Thank you both of you, I'll give the compact and repair a try.

    No, they tried to change something, but then confused themselves and couldn't change it back ...
    Annoyingly, I am new to this database and there wasn't a recent backup made!

  11. #11
    beckyd89 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    6
    I fixed it! They had also amended the row source on the table, which is why it was affecting the form, but they told me they had only made changes to the form ... (as I said I am an Access novice, so apologies if this was an obvious place to check!)

    Thank you for both of your help!

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

Similar Threads

  1. Records not showing on form view
    By sunnyday in forum Database Design
    Replies: 2
    Last Post: 06-12-2015, 12:37 AM
  2. Replies: 3
    Last Post: 08-12-2014, 02:12 PM
  3. My combo box is only showing a few of the options
    By breakingme10 in forum Forms
    Replies: 2
    Last Post: 07-29-2014, 03:29 PM
  4. Showing all records in Form view
    By DesignGuy in forum Forms
    Replies: 5
    Last Post: 03-30-2012, 02:58 PM
  5. fields not showing up in Form view
    By eroy in forum Forms
    Replies: 3
    Last Post: 08-28-2010, 05:44 PM

Tags for this Thread

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