jsb17
03-15-2000, 09:12 PM
If a user types in data not in a combo box list, how can I write a macro to delete that text and return the control to a null entry>
|
View Full Version : Deleting text in a control jsb17 03-15-2000, 09:12 PM If a user types in data not in a combo box list, how can I write a macro to delete that text and return the control to a null entry> cinnamoncw 03-16-2000, 07:03 AM You can avoid having the user enter information that is not in your combo box. In table design, under the Lookup Tab, set the Field Property "limit to list" to YES. When the user types in an incorrect entry on the form, a box will pop-up informing him/her that the text is not in the list and that s/he must re-enter the field. |