Non-editable Textbox

[G2K]

Hi All,

I am using a textbox on excel vba form to select cretaria to search in acess database. i just want it to male non-editable. i have used Keyprss event to make keyascii value zero but it is not applicable for delete and backspace buttons. can anybody help...............

thanks in Advance...........

 

[Tom Urtis]

Can you not simply set its Locked property to True?

Or use a Label control instead?

 

[G2K]

thans for ur quick reply,

if i set lock property as true, how can user be able to select search cretaria as textbox is locked.

please explain if i am wrong.

 

[G2K]

i am extremly sorry, this is combo box not text box

 

[Tom Urtis]

OK, so it's a combobox.

Set its Style property to
2-fmStyleDropDownList

 

[G2K]

it's working .......


thanks a ton ....