Problem with ComboBox in access 2016
Hi Experts,
I have a question about Combo box in access 2016. The combo box was working fine in my program before I convert to Office 365 Access 2016. Now the combo box in Access 2016 has a problem that I couldn't figure it out why it happen and don't know how to fix. The problem is:
I have a combo box that has a list of items from a query, the length of the items some are short and some are longer. when users select from the combo box, the shorter length items show no problems, the users can see the item in the combo box right after they selected. But there is a problem with the longer text item, it cuts off the first half part of the item right after the users select and only shows the other half part of the item in the combo box until users click on the any field in the form then the whole item shows in the comboBox. I don't know why it happen in access 2016. Any help how to fix would be very appreciated
I have a question about Combo box in access 2016. The combo box was working fine in my program before I convert to Office 365 Access 2016. Now the combo box in Access 2016 has a problem that I couldn't figure it out why it happen and don't know how to fix. The problem is:
I have a combo box that has a list of items from a query, the length of the items some are short and some are longer. when users select from the combo box, the shorter length items show no problems, the users can see the item in the combo box right after they selected. But there is a problem with the longer text item, it cuts off the first half part of the item right after the users select and only shows the other half part of the item in the combo box until users click on the any field in the form then the whole item shows in the comboBox. I don't know why it happen in access 2016. Any help how to fix would be very appreciated
When you select an item in a combobox, the entire text of the item should be selected (highlighted) in the combobox.
Is the entire item text selected in your combobox, or is there a cursor showing somewhere?
An image (screenshot, snagit or Windows Snipping Tool) of a "malfunctiong display" in your combobox would help a lot.
Is the entire item text selected in your combobox, or is there a cursor showing somewhere?
An image (screenshot, snagit or Windows Snipping Tool) of a "malfunctiong display" in your combobox would help a lot.
This also may require knowing what version you have. Go to Access's File tab and select "Account", then "About Access" and include a screenshot of your version like below:
ASKER
@Mark,
I'm using MS Office 365 - Access 64-bit.
sorry for the confusion. my short text in the comboBox drop down means: less than 10 characters. Long text means more than 60 chatacters.
"When you select an item in a combobox, the entire text of the item should be selected (highlighted) in the combobox." -- Yes, it was highlighted and the entire item text selected in your combobox but instead showing the entire item in the comboBox, the first part of the item does not showing in the combo box and only showing the last half of the item unless we moved the cursor to anywhere of the form or go to other field then the whole item would show in the combo box, I never have any issues like that before. I even created a new combo box and it had same problem.
Thanks,
I'm using MS Office 365 - Access 64-bit.
sorry for the confusion. my short text in the comboBox drop down means: less than 10 characters. Long text means more than 60 chatacters.
"When you select an item in a combobox, the entire text of the item should be selected (highlighted) in the combobox." -- Yes, it was highlighted and the entire item text selected in your combobox but instead showing the entire item in the comboBox, the first part of the item does not showing in the combo box and only showing the last half of the item unless we moved the cursor to anywhere of the form or go to other field then the whole item would show in the combo box, I never have any issues like that before. I even created a new combo box and it had same problem.
Thanks,
Can you post a screenshot of the long items not showing?
Have you set the column width in thew dropdown to more than the longest text width you expect?
Have you set the column width in thew dropdown to more than the longest text width you expect?
sounds like the combo col width is too short as when you move the focus to another control the text is visible in the combo box field.
screenshot ?
I've never used Access 64-bit (I avoid it religiously)
I couldn't duplicate the situation in 32-bit Access O365 A2016.
Sounds like folks are making a lot guesses as to what you are talking about, confusing the width of the columns (if any) in the dropdown list vs the display of the selected item after one is selected.
You're going to need to be patient on this one.
I couldn't duplicate the situation in 32-bit Access O365 A2016.
Sounds like folks are making a lot guesses as to what you are talking about, confusing the width of the columns (if any) in the dropdown list vs the display of the selected item after one is selected.
You're going to need to be patient on this one.
Please post a screenshot so we can help you better
Is the combo right justified? Are you sure you didn't have the problem with the old version? Perhaps, the new version is using a different font because the original is not supported.
ASKER
I will post a screen shot later
ASKER
@PatHartman,
You were right about the font problem. but something was really weir, I tried again today, it was working fine. There was problems last Tuesday. I'm so confuse . So if in that case, is any way to fix about font, I'm using 9, I can't down to 8, it's too small for the users to see.
You were right about the font problem. but something was really weir, I tried again today, it was working fine. There was problems last Tuesday. I'm so confuse . So if in that case, is any way to fix about font, I'm using 9, I can't down to 8, it's too small for the users to see.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Pathartman,
I did try to change to different font and still not working. I notice if the items in the drop down shorter than the with of the combo box, it shows everything, however, if the item in the drop down excess the with of the combo box then part of the item got cut off.
I did try to change to different font and still not working. I notice if the items in the drop down shorter than the with of the combo box, it shows everything, however, if the item in the drop down excess the with of the combo box then part of the item got cut off.
Themes have also changed between versions. Different themes have different size fonts. Try changing the theme.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@all experts,
I think I figure it out. I changed the size of the ListWidth of the combo box. it seems working now. Thanks everyone efforts and time!
I think I figure it out. I changed the size of the ListWidth of the combo box. it seems working now. Thanks everyone efforts and time!
How many characters are we talking about here?
Also how does the length display relative to the length of the combobox?
Is the combobox wide enough to display the whole "long" item? (Sounds like it is...)
I'll run some test and see if I can duplicate.