disable combo box dropdown in non-edit mode (1 Viewer)

Q

QueenKirsty

Registered User.

Local time

Today, 05:26

Joined

Mar 13, 2009

Messages

31

• Sep 25, 2009

• #1

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

Remembered

Local time

Today, 05:26

Joined

Jun 8, 2005

Messages

8,632

• Sep 25, 2009

• #2

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

Code:Copy to clipboard

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

David

 

Q

QueenKirsty

Registered User.

Local time

Today, 05:26

Joined

Mar 13, 2009

Messages

31

• Sep 25, 2009

• #3

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

 

DCrake

Remembered

Local time

Today, 05:26

Joined

Jun 8, 2005

Messages

8,632

• Sep 25, 2009

• #4

I know, alot of people say that.

Anyway glad to see you solved your problem

David