If I want to put up a msgbox, I can specify the title that appears in the title bar on the top of the msgbox box with something like this:
msgbox "Here's the message",,"Here's the title"
If I want to do validation through access, I can set a validation rule for a field like this:
txtfld01.ValidationRule = "> 65"
txtfld01.ValidationText = "this field must be greater than 65"
But the msgbox that is displayed has a default value in the title, not the "Here's the title" header that is in the first msgbox above. Additionally I cannot reference all of the other msgbox features that I can when building my own, like the button that shows up in the box next to the message. And the beep that sounds in the case of a msgbox is not the same as the sound that comes from a Validation process.
Can I control what's in the title bar, and the sound?
TIA for any help