Hide Menu Drop Down Button

[Guest]

Thanks for taking the time to read my question.

I have a form that, when on an existing record the fields are unenabled and
locked so that data doesn't get changed by accident. On new records or when
user click the "Edit Data" button, the fields become enabled and unlocked.

When the combo box fields are locked and unenabled I also have the Special
Effect = Flat, Transparent border and the Background color of the fields = to
the same color as the form background color. This works perfectly, but I
would like the Drop Down buttons to hide as well. The form looks silly with
them there. There is just this button with a down arrow that does nothing
out to the right of the text that is in the field.

 

[Ken Snell [MVP]]

Put a small rectangle (box) control on the form. Position it so its size and
location are just covering the dropdown arrow. Then set its Visible property
to True when you want to hide the combo box, else set Visible to False.

 

[Guest]

Thanks so much Ken,

I thought of that, but then thought that the box would get in the way. I
forgot that when something is not visible it is not clickable.

Thanks again,

Brad