IsBlank function run on form will not allow initial save of bank value to send to users

I have the following code to prevent users from being able to save the form blank to send. However I need to be able to send the user a blank form innitially I can not figure out how to do this, Please advise.

Please Login or Register  to view this content.

Disable macros before opening this file. Then fix your code, and save.

Hi lengwer,

To iniitialize your data try the following in an ordinary code module such as 'Module1':

Please Login or Register  to view this content.

Your routine checks for empty cells, but does not check for cells that contain blanks and no other characters. I added 'MyIsEmpty()' to replace 'IsEmpty()'.

MyIsEmpty():
a. Checks for empty cell
b. Checks for cell that contains only spaces (BLANKS)
c. Removes leading and trailing spaces from non-BLANK cells

Please Login or Register  to view this content.

Lewis

Thank you all for the information (Sorry for spelling errors in advance). I did figure out the issue myself. I also concatenated the msgbox to contain all of the errors at once. I created the following code to cover three scenarios:

1. Will save if all fields are null
2. Will not save if one or more of the required fields are null
3. Will save if all fields required are completed.

Please Login or Register  to view this content.

I will definitly change the code to reflect the MyIsEmpty() rather than the IsEmpty(). I can see where this would benifit. Thank you again for the information and the quick responses.