Combo box

[Ron]

Hi ,

I have a form with combo box.

In case the user type in value that is not in the combo list,
I would like him to get a massage "Invalid entry".

Any ideas?

Thanks

 

[Guest]

First open your form in design mode. Open the properties menu and goto the
data page. Set the 'Limit to List' property to Yes.

Then goto the Event page and select the 'On Not in List' and click on the
.... (right hand) choose to code builder. The VBE window will open. Enter
the following

msgbox "Invalid entry"

Save your changes and try it out.

you should also note that by simply setting the 'Limit to List' property to
Yes, access will not allow the user to enter invalid entries and will display
it's default message. you should check it out, it may suffice your needs
without requiring you to create an event and do any programming!

 

[Tom]

Thanks,
Setting the the 'Limit to List ' was suffice.