I have tried some code a few users have given me and none have worked. All I want to do is the following:
I have a text box on my access form. Well I want access to be able to be able to tell if the txt box contains text or is blank. If the text box is left blank, I want a message box to appear stating "Please enter text". If the text box has text, I just want to be able to go on to the next text box.
There has to be a way to do this.
I tried this code:
If text46 = "" then
msgbox "Enter data"
cancel = true
This does not work. All it does is when I enter a value into text46, it will not let me go to the next text box. This is the complete opposite of what I want to happen. I want that to happen when the box is left blank. Please help I am about to give up