How to warn user when they type in the textbox

[hkgary33 via AccessMonster.com]

Dear all,
In my form which allows user to input data to records, it consists of a
textbox named "FileType". How can I write in the event procedure such that in
the first time, i.e. when the textbox is originally empty, it allows user to
input text in it. But later on, when the user want to change the text in this
textbox (which already have text in it), it will shows a warning message to
warn the user whether to change the text in it or not, if the user choose
"Yes", the change will be confirmed, if "No" is choosen, it will remain the
textbox unchange.

Thanks a lot!!
Gary

 

[Guest]

hi gary,

quite new to this myslef but try this code on the 'before insert' event of
your field

If vbNo = MsgBox("Do you want to change the text?", _
vbQuestion + vbYesNo + vbDefaultButton1, "Change Text?") Then
cancel=true
end if

i hope this helps

richard