Combobox abbreviating my columns (1 Viewer)

Natham

New member
Local time
Today, 03:36
Joined
Dec 1, 2019
Messages
3
Hello! I am new to access and I am having a problem with my combobox: it has 4 columns, they are all showing in the dropdown however one column, i admit, is a little large and the combobox is only showing two letters of the word or the first two letters of two words

an example is this
INSTEAD OF SHOWINF THIS:
id_dia / dia / clase / hora
DKBN / DOMINGO / KICKBOXING + NINJUTSU / 16:00

IS SHOWING:

id_dia / dia / clase / hora
DKBN / DOMINGO / KN / 16:00

I tried changing the column widths but it doesnt solve the problem. the thing that it might get confusing for the user and i would like to avoid that

thank you very much!
 

mike60smart

Registered User.
Local time
Today, 10:36
Joined
Aug 6, 2017
Messages
1,899
Hi Natham

Welcome to the Forum

You will also need to change the List Width as well as Column Widths
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:36
Joined
May 21, 2018
Messages
8,463
I doubt that has anything to do with any widths
KICKBOXING + NINJUTSU becomes KN? No column width is going to do that.

Is that a single string "KICKBOXING + NINJUTSU" or are you concatenating? Use & instead.
 

mike60smart

Registered User.
Local time
Today, 10:36
Joined
Aug 6, 2017
Messages
1,899
Very True MajP I completely misread the question
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:36
Joined
May 21, 2018
Messages
8,463
Very True MajP I completely misread the question
However, I still have no clue how that would even be possible, if that is really happening. Unless those are the PKs "K" and "N" and the op is concatenating a table with drop down lists. So the table shows Kickboxing but the real value is "K"
 

mike60smart

Registered User.
Local time
Today, 10:36
Joined
Aug 6, 2017
Messages
1,899
Hi

Can you upload a zipped copy of the Db so we can see the properties of the Combo Box?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:36
Joined
Oct 29, 2018
Messages
21,357
Hi Natham. Welcome to AWF! If you can't post a copy of your db, can you please show us the Row Source of your Combobox? If it's a name of a query, please show us the SQL statement of that query instead. Thanks!
 

Natham

New member
Local time
Today, 03:36
Joined
Dec 1, 2019
Messages
3
its a bit heavy :( i'll upload a screenshot

statement sql:
SELECT HORARIOS.ID_DIA, HORARIOS.DIA, HORARIOS.CLASE, HORARIOS.HORA
FROM HORARIOS
ORDER BY HORARIOS.DIA, HORARIOS.HORA;

then the combo box has this:

Private Sub ID_DIA_ASIS_Change()
Me.DIA_ASIS = Me.ID_DIA_ASIS.Column(1)
Me.CLASE_ASIS = Me.ID_DIA_ASIS.Column(2)
Me.HORA_ASIS = Me.ID_DIA_ASIS.Column(3)
End Sub

i think its suuuper simple however its abbreviating all the records i cant figure why


thank you!!
 

Attachments

  • screen access.jpg
    screen access.jpg
    98 KB · Views: 30
Last edited:

MajP

You've got your good things, and you've got mine.
Local time
Today, 06:36
Joined
May 21, 2018
Messages
8,463
As I said, do you have a lookup list in the table where those values are primary keys?
 

mike60smart

Registered User.
Local time
Today, 10:36
Joined
Aug 6, 2017
Messages
1,899
Looks like you are storing the abbreviation ie KB vice the Primary Key
 

Users who are viewing this thread

Top Bottom