Solved Display Image

[smtazulislam]

Hi,
Is it possible in ms access for display Image in the Combobox Column. DB has attached. it need to work in frmTransaction Form in combobox.
I haven't find in google search for ms access.
Appreciate to help.

 

[theDBguy]

Hi. I don't think so. Maybe you can use a subform instead. Just a thought...

 

[smtazulislam]

Hi. I don't think so. Maybe you can use a subform instead. Just a thought...

Instead subform How ?

 

[theDBguy]

Instead subform How ?

By using some code that will simulate Combobox functionality but using a subform for the dropdown options.

 

[smtazulislam]

theDBguy I wanting like attached picture.

 

[theDBguy]

theDBguy I wanting like attached picture. View attachment 84229

If you create a Form that looks like that, then you can use it as a subform. The only trick is, how to make it behave like a Combobox.

 

[smtazulislam]

Thanks for your reply. can I get a demo...

 

[theDBguy]

Thanks for your reply. can I get a demo...

Hi. The only demo I could think of is one where it shows how to use a subform as a dropdown, but it doesn't have images. I tried to search for it, but can't find it at the moment.

 

[arnelgp]

there is an ActiveX available, it's call ImageCombobox.
see this sample.

 

[smtazulislam]

arnelgp Thank you so much for reply, I can't open it, there is some error.

 

[arnelgp]

view the form in design view.
do you see the ImageList0 control and the ImageCombo1 control.
if you don't you need to add them using ActiveX Controls.

Microsoft ImageList Control, and
Microsoft ImageCombobox Control

 

[smtazulislam]

view the form in design view.
do you see the ImageList0 control and the ImageCombo1 control.
if you don't you need to add them using ActiveX Controls.

Microsoft ImageList Control, and
Microsoft ImageCombobox Control

Yes, I see this ImageList0 control and the ImageCombo1 control.
But, How to fix this error ?
and I dont know about "Microsoft ImageList Control, and Microsoft ImageCombobox Control".

 

[arnelgp]

check if you have those control on your pc.
create new form.
on the Ribbon, select ActiveX Controls.

the demo will look like this.

 

[smtazulislam]

check if you have those control on your pc.
create new form.
on the Ribbon, select ActiveX Controls.

the demo will look like this.

Thanks for demo. Yes, I wanting like that. I appreciate you well understand me.
Yes, I create a new form that name frmTest select "ActiveX Controls" and selected Microsoft Form 2.0 Combo box. And combo box name is ComboBox0 .
Then what is the next ?

 

[arnelgp]

no that's not the one.
look for:

Microsoft ImageList Control (you will save your image here).
Microsofr ImageCombobox Control (you will Tie the Imagelist here).

those 2 controls are just below Microsoft Form controls.

''''
'/ EDIT
i think maybe you don't have those controls, coz if you do, you will not get error
when you open my demo.

i have windows 10 and office 2019.

 

[smtazulislam]

I dont find Microsoft ImageList Control. Microsoft Form 2.0 Image . Look my page screen.

And I using windows 10 Pro and office 2016.

 

[arnelgp]

Scroll Down further, it is not in Microsoft Form as i already told you.

 

[smtazulislam]

Please check this video. I think I dont have. its .wmv format

 

[Gasman]

I dont find Microsoft ImageList Control. Microsoft Form 2.0 Image . Look my page screen.View attachment 84253

And I using windows 10 Pro and office 2016.

As arnelgp mentioned, it is not in Forms, plus the list is alphabetical.?

 

[arnelgp]

how come you don't have them?
there are already discussion on the net as far as 2016
about this control.