We help IT Professionals succeed at work.

Problem with ComboBox in access 2016

urjudo
urjudo asked
on
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
Comment
Watch Question

Mark EdwardsChief Technology Officer

Commented:
My first question is what constitutes the difference between a "short" combobox item and a "long" combobox item.
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.
Mark EdwardsChief Technology Officer

Commented:
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.
Mark EdwardsChief Technology Officer

Commented:
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:
Access-File-Version-Snippet.PNG

Author

Commented:
@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,
Partha MandayamTechnical Director

Commented:
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?
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 ?
Mark EdwardsChief Technology Officer

Commented:
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.
Partha MandayamTechnical Director

Commented:
Please post a screenshot so we can help you better
Distinguished Expert 2017

Commented:
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.

Author

Commented:
I will post a screen shot later

Author

Commented:
@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.
Distinguished Expert 2017
Commented:
The numbers are point size.  Try a different font.  Some fonts are easier to read at smaller sizes than others.  For small sizes, many people like sans-serif (no descenders) because they have a cleaner look.  Notice that the y's in this message descend below the bottom of the other characters.  Try Ariel and see if that helps.

Author

Commented:
@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.
Distinguished Expert 2017

Commented:

Themes have also changed between versions.  Different themes have different size fonts.  Try changing the theme.

Chief Technology Officer
Commented:
I was able to get a textbox to display a long string with the beginning of the string about halfway in the center of the textbox and extending thru the end when the text was selected when the textbox got the focus when tabbing thru the controls, but clicking off the textbox made the text display normally.
The textbox was right-aligned.

With a little more testing, I was able to get it to do that with a combobox as well.

Is the image showing something like you are seeing?
Right-Aligned-Textbox-2.PNGRight-Aligned-Textbox-3.PNGRight-Aligned-Textbox-4.PNGCheck to see if the control has an alignment assigned to it, or if it is just using the default.  Select the control in design mode and check the ribbon to see if it has a left, right, or center alignment assigned.

Author

Commented:
@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!