Thank you! That works beautifully, and I have made slight additions/changes
to it.

Thanks again!


Jay Freedman wrote:
Hi Michael,

Item 1: Select this macro as the exit macro for your field.

Item 2: Make sure you change "Text2" to "Text15" in all five places where it
occurs.

Item 3: You need to change the "If" statement (the third line of the
ExitText2 macro). The macro as you copied it from the web page is only an
example of the kind of thing you can do, and this particular example is
checking to be sure the field contents start with the letters KLM -- not
what you want. To check that the field is not empty, that line should be
replaced by

If Len(.Result) = 0 Then

You'll also want to change the message in the MsgBox statement to something
like "The date field cannot be blank".

Suzanne,

[quoted text clipped - 33 lines]
Thank you,
Michael


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...neral/200508/1