>try "set confirm on"
no effect. I did manage to get it to stay in the textbox, but once the value = .NULL., it won't hold a different value. After adding a check in the gotfocus method, I was able to stay in the textbox and edit, but it reverted to null after moving to another control, so once a null value is ever entered, it cannot be changed to something else
Jim Newsom
IT Director, ICG Inc.