For starters, don't use "Name" because it's a reserved word. Second, don't
use "!" to refer to a text box, use ".". Third, give your controls
meaningful prefixes - a lot of developers use "txt" for text boxes - it
helps make your code more understandable. So ... rename your calculated
field FullName, your text box txtFullName and try
If Me.txtFullName = "" Then
BUT ... is your calculated field really ever empty? Won't there be a space
and/or comma in it?