Custom "invalid property value" error for form combo field 1

[bluegnu]

I have a form with a combo field in with the MatchRequired option set to true.

Problem is, if you type in a non-match you get an error "invalid property value" which I can't seem to replace with a customer message.

I have tried:

On Error GoTo ErrFindClick
ErrFindClick:
MsgBox "Please select an item from the list.", vbOKOnly, "Please amend"

But it doesn't seem to matter where I place this in the code, the Invalid Property message always appears.

What can I do about this?

Many thanks

 

[PHV]

What about the NotInList event ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bluegnu]

Thanks for the response. I realise I wasn't complete in my original question, I am using Excel 2003 and I don't think it has the NotInList event or an equivalent..?

 

[PHV]

OOps, sorry.
You may consider testing the MatchFound property in the Change event instead of setting MatchRequired to true.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bluegnu]

Ah yes, that did it. Many thanks