Software

Ask something
Discussion Locked

Access Forms in XP

0 helpful
3 replies

by lf king

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Field in database requires Vehicle VIN#'s - want a message to pop up on the form for that field to ask if the data is correct if under 17 characters.

The field is a maximum of 17 digits, but depending on the type of vehicle it could be less.

3 replies

by piratetoolz

for the On Exit property of the text box, assign an event and code it like this:

'Compare the length of text in the control. test is what i called my textbox.
__________________________________________________
If Len(test.text)< 17 then msgbox "Whoa there buddy, are you sure that VIN# is correct?"
__________________________________________________
You could of course change the message box to meet your needs (with yes or no responses). I hope this helps.

This discussion is closed to new replies.