disable combo box dropdown in non-edit mode

[QueenKirsty]

I have a form which can be in edit or non-edit modes. In non edit mode I DO NOT want the combo baxes to expand when clicked on but I do not want to disable them as the appear all faded and are not easy to read.

Is there any way to make the combo box appear as normal but not expand when it is clicked on?

 

[DCrake]

If you combine the .Locked property in conjunction with the .Enabled property then the control is not ghosted.

Me.Cbo.Enabled = False
Me.Cbo.Locked = True

David

 

[QueenKirsty]

Complete genius and total star! I had been searching this for hours!!!
Thanks!!!

 

[DCrake]

I know, alot of people say that.

Anyway glad to see you solved your problem

David